/*
 Navicat Premium Data Transfer

 Source Server         : 金豆优拼
 Source Server Type    : MySQL
 Source Server Version : 80017
 Source Host           : localhost
 Source Database       : ylmall

 Target Server Type    : MySQL
 Target Server Version : 80017
 File Encoding         : utf-8

 Date: 05/13/2020 14:38:55 PM
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `access`
-- ----------------------------
DROP TABLE IF EXISTS `access`;
CREATE TABLE `access` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `rule_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '角色',
  `menu_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '菜单',
  PRIMARY KEY (`id`),
  UNIQUE KEY `role_menu_unique` (`rule_id`,`menu_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=138 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='权限表';

-- ----------------------------
--  Records of `access`
-- ----------------------------
BEGIN;
INSERT INTO `access` VALUES ('2', '1', '4'), ('3', '1', '7'), ('4', '1', '8'), ('5', '1', '9'), ('17', '1', '10'), ('1', '1', '11'), ('6', '2', '3'), ('7', '2', '12'), ('8', '2', '13'), ('9', '2', '14'), ('10', '2', '15'), ('11', '2', '16'), ('12', '3', '17'), ('13', '3', '18'), ('14', '3', '19'), ('15', '3', '20'), ('16', '3', '21'), ('85', '5', '22'), ('84', '5', '23'), ('83', '5', '24'), ('82', '5', '25'), ('81', '5', '26'), ('80', '5', '27'), ('79', '5', '28'), ('78', '5', '39'), ('77', '5', '40'), ('76', '5', '41'), ('75', '5', '61'), ('74', '5', '62'), ('25', '6', '29'), ('26', '6', '30'), ('27', '6', '31'), ('28', '6', '32'), ('29', '6', '33'), ('133', '8', '52'), ('132', '8', '53'), ('131', '8', '54'), ('130', '8', '56'), ('129', '8', '57'), ('128', '8', '58'), ('41', '9', '39'), ('40', '9', '40'), ('39', '9', '41'), ('55', '10', '42'), ('54', '10', '43'), ('53', '10', '44'), ('52', '10', '45'), ('51', '10', '47'), ('50', '10', '49'), ('89', '16', '2'), ('88', '16', '63'), ('87', '16', '65'), ('86', '16', '66'), ('121', '17', '34'), ('120', '17', '36'), ('119', '17', '37'), ('118', '17', '38'), ('117', '17', '39'), ('116', '17', '45'), ('127', '18', '46'), ('126', '18', '47'), ('125', '18', '48'), ('124', '18', '49'), ('123', '18', '50'), ('122', '18', '51'), ('137', '19', '53'), ('136', '19', '55'), ('135', '19', '59'), ('134', '19', '60');
COMMIT;

-- ----------------------------
--  Table structure for `account`
-- ----------------------------
DROP TABLE IF EXISTS `account`;
CREATE TABLE `account` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '类型(0为支付宝,1为微信,2为银行卡,默认0)',
  `member_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '会员',
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '0' COMMENT '姓名',
  `account` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '0' COMMENT '账号',
  `mobile` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '0' COMMENT '手机号码',
  `stats` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '状态(0为启用,1为禁用,默认1)',
  `extend_field` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '拓展字段(包含发卡行,发卡行所在省市等)',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '编辑时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique` (`type`,`member_id`) USING BTREE,
  KEY `member_id` (`member_id`) USING BTREE,
  KEY `type` (`type`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用户提现账号信息';

-- ----------------------------
--  Records of `account`
-- ----------------------------
BEGIN;
INSERT INTO `account` VALUES ('2', '0', '6', '黄旭', 'huangxu4328@163.com', '1311111111', '1', null, '2020-03-23 20:36:47', '2020-03-24 13:53:30');
COMMIT;

-- ----------------------------
--  Table structure for `ad`
-- ----------------------------
DROP TABLE IF EXISTS `ad`;
CREATE TABLE `ad` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '广告编号',
  `name` varchar(100) NOT NULL DEFAULT '' COMMENT '广告名称',
  `img` varchar(255) NOT NULL DEFAULT '' COMMENT '广告图片',
  `type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '广告类型（1 拼团图片 2 淘宝图片 3拼团banner 4淘宝banner 5搜索框广告）',
  `ad_addr_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '广告地址类型（1url 2商品id 3关键词）',
  `ad_addr` varchar(255) NOT NULL DEFAULT '' COMMENT '广告地址',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态;1:显示;0:隐藏 默认为1',
  `past_time` datetime DEFAULT '0000-00-00 00:00:00' COMMENT '过期时间（默认0）',
  `order` int(11) NOT NULL DEFAULT '0' COMMENT '排序（默认0)',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `created_by` int(11) NOT NULL DEFAULT '0' COMMENT '创建者',
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '编辑时间',
  `updated_by` int(11) NOT NULL DEFAULT '0' COMMENT '编辑者',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='广告';

-- ----------------------------
--  Records of `ad`
-- ----------------------------
BEGIN;
INSERT INTO `ad` VALUES ('5', '测试广告', '/upload/ad_image/5eb9f2eec922a.png', '3', '1', 'https://www.baidu.com', '1', '0000-00-00 00:00:00', '122', '2020-04-12 22:03:44', '66', '2020-05-12 08:51:40', '66'), ('7', '测试广告1', '/upload/ad_image/5eb9f2c5d61e6.png', '1', '2', '584051070147', '1', '0000-00-00 00:00:00', '100', '2020-04-13 09:12:08', '66', '2020-05-12 08:50:25', '66');
COMMIT;

-- ----------------------------
--  Table structure for `address`
-- ----------------------------
DROP TABLE IF EXISTS `address`;
CREATE TABLE `address` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `member_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '所属会员',
  `is_default` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否默认地址(0为否,1为是,默认1)',
  `province` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '省份',
  `city` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '城市',
  `area` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '区县',
  `street` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '街道',
  `location` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '详细地址',
  `name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '收货人姓名',
  `zipcode` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '邮编',
  `mobile` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '收货人手机号',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `member_id` (`member_id`) USING BTREE,
  KEY `is_default` (`is_default`) USING BTREE,
  KEY `mobile` (`mobile`) USING BTREE,
  KEY `name` (`name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='收货地址';

-- ----------------------------
--  Records of `address`
-- ----------------------------
BEGIN;
INSERT INTO `address` VALUES ('3', '6', '0', '福建省', '厦门市', '海沧区', '新阳街道', 'A栋1201', '黄旭', '361009', '13779957421', '2020-03-19 12:16:33'), ('4', '6', '0', '福建省1', '厦门市', '海沧区', '新阳街道', 'A栋1201', '黄旭', '361009', '13779957421', '2020-03-19 12:16:33'), ('6', '6', '1', '福建省', '厦门市', '湖里', '金山', '上湖', '黄', '0', '13666666666', '2020-03-19 12:16:33'), ('7', '6', '0', '福建省1', '厦门市', '海沧区', '新阳街道', '1111', '黄旭', '361009', '13779957421', '2020-03-19 12:16:33');
COMMIT;

-- ----------------------------
--  Table structure for `albums`
-- ----------------------------
DROP TABLE IF EXISTS `albums`;
CREATE TABLE `albums` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '类型(0为主贴的图片,1为产品的图片,2为回帖的图片,3为上传退货凭证)',
  `album` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '图片的序列化字符串',
  `stats` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '审核状态(0为未审核,1为已审核,2为审核不通过)',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '编辑时间',
  `updated_by` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '审核人员',
  PRIMARY KEY (`id`),
  KEY `type` (`type`) USING BTREE,
  KEY `stats` (`stats`) USING BTREE,
  KEY `updated_by` (`updated_by`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=106 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='图片表';

-- ----------------------------
--  Records of `albums`
-- ----------------------------
BEGIN;
INSERT INTO `albums` VALUES ('16', '0', 'a:2:{i:0;s:22:\"/public/upload/123.png\";i:1;s:22:\"/public/upload/234.jpg\";}', '1', '2019-02-15 14:26:06', '2019-02-15 14:26:06', '0'), ('20', '1', 'a:2:{i:0;s:28:\"/public/upload/product_1.jpg\";i:1;s:28:\"/public/upload/product_2.png\";}', '1', '2019-02-16 18:56:16', '2019-02-16 18:56:16', '0'), ('22', '1', 'a:2:{i:0;s:28:\"/public/upload/product_1.jpg\";i:1;s:28:\"/public/upload/product_2.png\";}', '1', '2019-02-16 19:09:54', '2019-02-16 19:09:54', '0'), ('24', '1', 'a:2:{i:0;s:25:\"/public/upload/reply1.jpg\";i:1;s:25:\"/public/upload/reply2.png\";}', '1', '2019-02-18 12:01:45', '2019-02-18 12:01:45', '0'), ('25', '1', 'a:2:{i:0;s:25:\"/public/upload/reply1.jpg\";i:1;s:25:\"/public/upload/reply2.png\";}', '1', '2019-02-18 12:02:21', '2019-02-18 12:02:21', '0'), ('26', '1', 'a:2:{i:0;s:25:\"/public/upload/reply1.jpg\";i:1;s:25:\"/public/upload/reply2.png\";}', '1', '2019-02-18 12:02:42', '2019-02-18 12:02:42', '0'), ('27', '0', 'a:1:{i:0;s:30:\"/upload/post/5c7492a31b4ca.jpg\";}', '1', '2019-02-26 09:17:20', '2019-02-26 09:17:20', '0'), ('28', '0', 'a:4:{i:0;s:30:\"/upload/post/5c7496b798957.jpg\";i:1;s:30:\"/upload/post/5c7496ba4be54.jpg\";i:2;s:30:\"/upload/post/5c7496bd3a371.jpg\";i:3;s:30:\"/upload/post/5c7496bfbd95c.jpg\";}', '1', '2019-02-26 09:33:09', '2019-02-26 09:33:09', '0'), ('29', '0', 'a:2:{i:0;s:30:\"/upload/post/5c74977bd790e.jpg\";i:1;s:30:\"/upload/post/5c74977e9d800.jpg\";}', '1', '2019-02-26 09:33:51', '2019-02-26 09:33:51', '0'), ('30', '0', 'a:6:{i:0;s:30:\"/upload/post/5c749856e5b7e.jpg\";i:1;s:30:\"/upload/post/5c7498598edec.jpg\";i:2;s:30:\"/upload/post/5c74985c2690b.jpg\";i:3;s:30:\"/upload/post/5c74985f63a91.jpg\";i:4;s:30:\"/upload/post/5c749861ac367.jpg\";i:5;s:30:\"/upload/post/5c74986433c68.jpg\";}', '1', '2019-02-26 09:37:42', '2019-02-26 09:37:42', '0'), ('31', '0', 'a:2:{i:0;s:30:\"/upload/post/5c749da4d1ffc.jpg\";i:1;s:30:\"/upload/post/5c749da7e94cd.jpg\";}', '1', '2019-02-26 10:00:10', '2019-02-26 10:00:10', '0'), ('32', '0', 'a:1:{i:0;s:30:\"/upload/post/5c749dda15d86.jpg\";}', '1', '2019-02-26 10:01:53', '2019-02-26 10:01:53', '0'), ('33', '0', 'a:2:{i:0;s:30:\"/upload/post/5c749e670e874.jpg\";i:1;s:30:\"/upload/post/5c749e6994ba1.jpg\";}', '1', '2019-02-26 10:03:43', '2019-02-26 10:03:43', '0'), ('34', '1', 'a:6:{i:0;s:34:\"/upload/product/5c74e5ce1a06a.jpeg\";i:1;s:34:\"/upload/product/5c74e5d0c6a15.jpeg\";i:2;s:34:\"/upload/product/5c74e5d37f755.jpeg\";i:3;s:34:\"/upload/product/5c74e5d69daac.jpeg\";i:4;s:34:\"/upload/product/5c74e5d90f686.jpeg\";i:5;s:34:\"/upload/product/5c74e5dc151ed.jpeg\";}', '1', '2019-02-26 15:08:29', '2019-02-26 15:08:29', '0'), ('35', '0', 'a:6:{i:0;s:30:\"/upload/post/5c7577acb9775.jpg\";i:1;s:30:\"/upload/post/5c7577af2d9ee.jpg\";i:2;s:30:\"/upload/post/5c7577b17cf55.jpg\";i:3;s:30:\"/upload/post/5c7577b3e2244.jpg\";i:4;s:30:\"/upload/post/5c7577b632870.jpg\";i:5;s:30:\"/upload/post/5c7577b8d8af6.jpg\";}', '1', '2019-02-27 01:30:36', '2019-02-27 01:30:36', '0'), ('36', '0', 'a:6:{i:0;s:30:\"/upload/post/5c7577acb9775.jpg\";i:1;s:30:\"/upload/post/5c7577af2d9ee.jpg\";i:2;s:30:\"/upload/post/5c7577b17cf55.jpg\";i:3;s:30:\"/upload/post/5c7577b3e2244.jpg\";i:4;s:30:\"/upload/post/5c7577b632870.jpg\";i:5;s:30:\"/upload/post/5c7577b8d8af6.jpg\";}', '1', '2019-02-27 01:30:46', '2019-02-27 01:30:46', '0'), ('37', '0', 'a:6:{i:0;s:30:\"/upload/post/5c7577acb9775.jpg\";i:1;s:30:\"/upload/post/5c7577af2d9ee.jpg\";i:2;s:30:\"/upload/post/5c7577b17cf55.jpg\";i:3;s:30:\"/upload/post/5c7577b3e2244.jpg\";i:4;s:30:\"/upload/post/5c7577b632870.jpg\";i:5;s:30:\"/upload/post/5c7577b8d8af6.jpg\";}', '1', '2019-02-27 01:31:00', '2019-02-27 01:31:00', '0'), ('38', '0', 'a:1:{i:0;s:30:\"/upload/post/5c7581cb8b5dd.jpg\";}', '1', '2019-02-27 02:13:38', '2019-02-27 02:13:38', '0'), ('39', '0', 'a:1:{i:0;s:30:\"/upload/post/5c7581cb8b5dd.jpg\";}', '1', '2019-02-27 02:13:55', '2019-02-27 02:13:55', '0'), ('40', '0', 'a:6:{i:0;s:30:\"/upload/post/5c7587743d7a8.jpg\";i:1;s:30:\"/upload/post/5c758776b8ef8.jpg\";i:2;s:30:\"/upload/post/5c75877a5b4b4.jpg\";i:3;s:30:\"/upload/post/5c75877da391d.jpg\";i:4;s:30:\"/upload/post/5c75878130ff1.jpg\";i:5;s:30:\"/upload/post/5c758783d64df.jpg\";}', '1', '2019-02-27 02:37:59', '2019-02-27 02:37:59', '0'), ('41', '1', 'a:6:{i:0;s:33:\"/upload/product/5c75c6377e899.jpg\";i:1;s:33:\"/upload/product/5c75c63a18be6.jpg\";i:2;s:33:\"/upload/product/5c75c63d39f16.jpg\";i:3;s:33:\"/upload/product/5c75c6419c80d.jpg\";i:4;s:33:\"/upload/product/5c75c6442a9c4.jpg\";i:5;s:33:\"/upload/product/5c75c64788c34.jpg\";}', '1', '2019-02-27 07:05:47', '2019-02-27 07:05:47', '0'), ('42', '1', 'a:5:{i:0;s:33:\"/upload/product/5c75cb9c6b2f4.jpg\";i:1;s:33:\"/upload/product/5c75cb9edbd4f.jpg\";i:2;s:33:\"/upload/product/5c75cba17c29e.jpg\";i:3;s:33:\"/upload/product/5c75cba476aec.jpg\";i:4;s:33:\"/upload/product/5c75cba6eeebf.jpg\";}', '1', '2019-02-27 07:29:36', '2019-02-27 07:29:36', '0'), ('43', '7', 'a:4:{i:0;s:26:\"/upload//5c76023848826.jpg\";i:1;s:26:\"/upload//5c7602384aebb.jpg\";i:2;s:26:\"/upload//5c76023853ff5.jpg\";i:3;s:26:\"/upload//5c76023856034.jpg\";}', '1', '2019-02-27 11:23:04', '2019-02-27 11:23:04', '0'), ('44', '8', 'a:3:{i:0;s:26:\"/upload//5c76071352526.jpg\";i:1;s:26:\"/upload//5c76071356d2a.png\";i:2;s:26:\"/upload//5c760713613ed.jpg\";}', '1', '2019-02-27 11:42:13', '2019-02-27 11:42:13', '0'), ('45', '8', 'a:3:{i:0;s:26:\"/upload//5c7607298b8b9.jpg\";i:1;s:26:\"/upload//5c7607298f22c.jpg\";i:2;s:26:\"/upload//5c76072992f00.jpg\";}', '1', '2019-02-27 11:42:35', '2019-02-27 11:42:35', '0'), ('46', '8', 'a:6:{i:0;s:26:\"/upload//5c76074a5d1d9.jpg\";i:1;s:26:\"/upload//5c76074a6124e.jpg\";i:2;s:26:\"/upload//5c76074a64507.jpg\";i:3;s:26:\"/upload//5c76074a66cc9.jpg\";i:4;s:26:\"/upload//5c76074a68d27.jpg\";i:5;s:26:\"/upload//5c76074a6c99d.jpg\";}', '1', '2019-02-27 11:43:08', '2019-02-27 11:43:08', '0'), ('47', '7', 'a:4:{i:0;s:26:\"/upload//5c76075e57d4c.jpg\";i:1;s:26:\"/upload//5c76075e5cec6.jpg\";i:2;s:26:\"/upload//5c76075e600c9.jpg\";i:3;s:26:\"/upload//5c76075e62ffb.jpg\";}', '1', '2019-02-27 11:43:28', '2019-02-27 11:43:28', '0'), ('48', '4', 'a:5:{i:0;s:26:\"/upload//5c7607a87e817.jpg\";i:1;s:26:\"/upload//5c7607a8830c5.jpg\";i:2;s:26:\"/upload//5c7607a886f23.jpg\";i:3;s:26:\"/upload//5c7607a88a7b3.jpg\";i:4;s:26:\"/upload//5c7607a890cd8.jpg\";}', '1', '2019-02-27 11:44:48', '2019-02-27 11:44:48', '0'), ('49', '9', 'a:4:{i:0;s:26:\"/upload//5c7607c161555.jpg\";i:1;s:26:\"/upload//5c7607c165bf3.jpg\";i:2;s:26:\"/upload//5c7607c1681ab.jpg\";i:3;s:26:\"/upload//5c7607c16a6c0.jpg\";}', '1', '2019-02-27 11:45:06', '2019-02-27 11:45:06', '0'), ('50', '8', 'a:4:{i:0;s:26:\"/upload//5c7607d960986.jpg\";i:1;s:26:\"/upload//5c7607d963ea4.jpg\";i:2;s:26:\"/upload//5c7607d9669c3.jpg\";i:3;s:26:\"/upload//5c7607d968a4f.jpg\";}', '1', '2019-02-27 11:45:30', '2019-02-27 11:45:30', '0'), ('51', '4', 'a:4:{i:0;s:26:\"/upload//5c7607f0125c1.jpg\";i:1;s:26:\"/upload//5c7607f0179d0.jpg\";i:2;s:26:\"/upload//5c7607f01c0b4.jpg\";i:3;s:26:\"/upload//5c7607f01fe15.jpg\";}', '1', '2019-02-27 11:45:53', '2019-02-27 11:45:53', '0'), ('52', '2', 'a:4:{i:0;s:26:\"/upload//5c76080a6db92.jpg\";i:1;s:26:\"/upload//5c76080a713cf.jpg\";i:2;s:26:\"/upload//5c76080a73ea3.jpg\";i:3;s:26:\"/upload//5c76080a75e6d.jpg\";}', '1', '2019-02-27 11:46:20', '2019-02-27 11:46:20', '0'), ('53', '4', 'a:9:{i:0;s:26:\"/upload//5c7608348fece.jpg\";i:1;s:26:\"/upload//5c760834935bb.jpg\";i:2;s:26:\"/upload//5c76083496283.jpg\";i:3;s:26:\"/upload//5c7608349b3af.jpg\";i:4;s:26:\"/upload//5c7608349e386.jpg\";i:5;s:26:\"/upload//5c760834de8a9.jpg\";i:6;s:26:\"/upload//5c760834ecfee.jpg\";i:7;s:26:\"/upload//5c760835161e2.jpg\";i:8;s:26:\"/upload//5c7608352d379.jpg\";}', '1', '2019-02-27 11:47:02', '2019-02-27 11:47:02', '0'), ('54', '5', 'a:4:{i:0;s:26:\"/upload//5c760851daeee.jpg\";i:1;s:26:\"/upload//5c760851ddca4.jpg\";i:2;s:26:\"/upload//5c760851e1afd.jpg\";i:3;s:26:\"/upload//5c760851e8398.jpg\";}', '1', '2019-02-27 11:47:31', '2019-02-27 11:47:31', '0'), ('55', '4', 'a:7:{i:0;s:26:\"/upload//5c760869a7548.jpg\";i:1;s:26:\"/upload//5c760869a2f9c.jpg\";i:2;s:26:\"/upload//5c760869aa277.jpg\";i:3;s:26:\"/upload//5c760869ac8dc.jpg\";i:4;s:26:\"/upload//5c760869b497f.jpg\";i:5;s:26:\"/upload//5c760869b6983.jpg\";i:6;s:26:\"/upload//5c760869cca2a.jpg\";}', '1', '2019-02-27 11:47:55', '2019-02-27 11:47:55', '0'), ('56', '3', 'a:5:{i:0;s:26:\"/upload//5c760881a0c3c.jpg\";i:1;s:26:\"/upload//5c760881a429f.jpg\";i:2;s:26:\"/upload//5c760881a678e.jpg\";i:3;s:26:\"/upload//5c760881a9dd7.jpg\";i:4;s:26:\"/upload//5c760881ade85.jpg\";}', '1', '2019-02-27 11:48:21', '2019-02-27 11:48:21', '0'), ('57', '1', 'a:5:{i:0;s:33:\"/upload/product/5c761f5423f67.jpg\";i:1;s:33:\"/upload/product/5c761f56ac481.jpg\";i:2;s:33:\"/upload/product/5c761f5944b72.jpg\";i:3;s:33:\"/upload/product/5c761f5c63655.jpg\";i:4;s:33:\"/upload/product/5c761f5ed1f2b.jpg\";}', '1', '2019-02-27 13:27:17', '2019-02-27 13:27:17', '0'), ('58', '1', 'a:1:{i:0;s:31:\"/upload/reply/5c772a10ad1e3.jpg\";}', '1', '2019-02-28 08:28:02', '2019-02-28 08:28:02', '0'), ('59', '1', 'a:3:{i:0;s:32:\"/upload/reply/5c772e1b1a4cd.jpeg\";i:1;s:32:\"/upload/reply/5c772e1da082f.jpeg\";i:2;s:32:\"/upload/reply/5c772e1fe055c.jpeg\";}', '1', '2019-02-28 08:41:05', '2019-02-28 08:41:05', '0'), ('60', '3', 'a:5:{i:0;s:27:\"/upload//5c78678c0965d.jpeg\";i:1;s:27:\"/upload//5c78678c0ea0d.jpeg\";i:2;s:27:\"/upload//5c78678c118d0.jpeg\";i:3;s:27:\"/upload//5c78678c393d3.jpeg\";i:4;s:27:\"/upload//5c78678c581c1.jpeg\";}', '1', '2019-03-01 06:58:32', '2019-03-01 06:58:32', '0'), ('61', '2', 'a:8:{i:0;s:27:\"/upload//5c7867b336068.jpeg\";i:1;s:27:\"/upload//5c7867b33a251.jpeg\";i:2;s:27:\"/upload//5c7867b34453b.jpeg\";i:3;s:27:\"/upload//5c7867b34e063.jpeg\";i:4;s:27:\"/upload//5c7867b351673.jpeg\";i:5;s:27:\"/upload//5c7867b35812e.jpeg\";i:6;s:27:\"/upload//5c7867b36b5e9.jpeg\";i:7;s:27:\"/upload//5c7867b381a55.jpeg\";}', '1', '2019-03-01 06:59:03', '2019-03-01 06:59:03', '0'), ('62', '10', 'a:5:{i:0;s:27:\"/upload//5c7867d583978.jpeg\";i:1;s:27:\"/upload//5c7867d58619b.jpeg\";i:2;s:27:\"/upload//5c7867d592fb1.jpeg\";i:3;s:27:\"/upload//5c7867d59d930.jpeg\";i:4;s:27:\"/upload//5c7867d5af465.jpeg\";}', '1', '2019-03-01 06:59:36', '2019-03-01 06:59:36', '0'), ('63', '11', 'a:7:{i:0;s:27:\"/upload//5c7867ea98d8a.jpeg\";i:1;s:27:\"/upload//5c7867ea9ca9d.jpeg\";i:2;s:27:\"/upload//5c7867ea9f439.jpeg\";i:3;s:27:\"/upload//5c7867eab11e7.jpeg\";i:4;s:27:\"/upload//5c7867eab34ce.jpeg\";i:5;s:27:\"/upload//5c7867eab71a8.jpeg\";i:6;s:27:\"/upload//5c7867eabdf56.jpeg\";}', '1', '2019-03-01 06:59:57', '2019-03-01 06:59:57', '0'), ('64', '11', 'a:5:{i:0;s:27:\"/upload//5c7868015aff6.jpeg\";i:1;s:27:\"/upload//5c7868015f64c.jpeg\";i:2;s:27:\"/upload//5c786801673bb.jpeg\";i:3;s:27:\"/upload//5c78680169544.jpeg\";i:4;s:27:\"/upload//5c7868016c0ea.jpeg\";}', '1', '2019-03-01 07:00:19', '2019-03-01 07:00:19', '0'), ('65', '11', 'a:5:{i:0;s:26:\"/upload//5c786817d9c1c.png\";i:1;s:26:\"/upload//5c786817e0b49.png\";i:2;s:26:\"/upload//5c786817eea13.png\";i:3;s:26:\"/upload//5c7868184ba8d.png\";i:4;s:26:\"/upload//5c78681865e31.png\";}', '1', '2019-03-01 07:00:42', '2019-03-01 07:00:42', '0'), ('66', '11', 'a:7:{i:0;s:27:\"/upload//5c786834bc885.jpeg\";i:1;s:27:\"/upload//5c786834c941b.jpeg\";i:2;s:27:\"/upload//5c786834d184f.jpeg\";i:3;s:27:\"/upload//5c786834dc9fa.jpeg\";i:4;s:27:\"/upload//5c786834decdd.jpeg\";i:5;s:27:\"/upload//5c786834e6ad0.jpeg\";i:6;s:27:\"/upload//5c786834ee916.jpeg\";}', '1', '2019-03-01 07:01:10', '2019-03-01 07:01:10', '0'), ('67', '10', 'a:6:{i:0;s:27:\"/upload//5c78684d5bcb1.jpeg\";i:1;s:27:\"/upload//5c78684d61c95.jpeg\";i:2;s:27:\"/upload//5c78684d64c0a.jpeg\";i:3;s:27:\"/upload//5c78684d678c9.jpeg\";i:4;s:27:\"/upload//5c78684d6d420.jpeg\";i:5;s:27:\"/upload//5c78684d74216.jpeg\";}', '1', '2019-03-01 07:01:35', '2019-03-01 07:01:35', '0'), ('68', '11', 'a:5:{i:0;s:27:\"/upload//5c78687ec5188.jpeg\";i:1;s:27:\"/upload//5c78687ed53af.jpeg\";i:2;s:26:\"/upload//5c78687f02168.png\";i:3;s:27:\"/upload//5c78687f043b0.jpeg\";i:4;s:26:\"/upload//5c78687f2e9d6.png\";}', '1', '2019-03-01 07:02:26', '2019-03-01 07:02:26', '0'), ('69', '11', 'a:5:{i:0;s:27:\"/upload//5c786898976df.jpeg\";i:1;s:27:\"/upload//5c786898a1cb1.jpeg\";i:2;s:27:\"/upload//5c786898a3e02.jpeg\";i:3;s:27:\"/upload//5c786898aab2a.jpeg\";i:4;s:26:\"/upload//5c786898d7d81.png\";}', '1', '2019-03-01 07:02:50', '2019-03-01 07:02:50', '0'), ('70', '2', 'a:2:{i:0;s:26:\"/upload//5c7868b0ae782.jpg\";i:1;s:26:\"/upload//5c7868b0b8599.jpg\";}', '1', '2019-03-01 07:03:15', '2019-03-01 07:03:15', '0'), ('71', '11', 'a:6:{i:0;s:27:\"/upload//5c7868c57b7ab.jpeg\";i:1;s:27:\"/upload//5c7868c5811f6.jpeg\";i:2;s:27:\"/upload//5c7868c584c4a.jpeg\";i:3;s:27:\"/upload//5c7868c59472b.jpeg\";i:4;s:27:\"/upload//5c7868c5bd749.jpeg\";i:5;s:27:\"/upload//5c7868c5c6e95.jpeg\";}', '1', '2019-03-01 07:03:35', '2019-03-01 07:03:35', '0'), ('72', '4', 'a:5:{i:0;s:27:\"/upload//5c7868d86f844.jpeg\";i:1;s:27:\"/upload//5c7868d87421a.jpeg\";i:2;s:27:\"/upload//5c7868d876787.jpeg\";i:3;s:27:\"/upload//5c7868d87b425.jpeg\";i:4;s:27:\"/upload//5c7868d883ed9.jpeg\";}', '1', '2019-03-01 07:03:54', '2019-03-01 07:03:54', '0'), ('73', '11', 'a:8:{i:0;s:27:\"/upload//5c7868eccce86.jpeg\";i:1;s:27:\"/upload//5c7868ecd6bd0.jpeg\";i:2;s:27:\"/upload//5c7868ecd95b8.jpeg\";i:3;s:27:\"/upload//5c7868ecebcd0.jpeg\";i:4;s:27:\"/upload//5c7868ecef324.jpeg\";i:5;s:27:\"/upload//5c7868ecf158e.jpeg\";i:6;s:27:\"/upload//5c7868ed01e57.jpeg\";i:7;s:27:\"/upload//5c7868ed08d20.jpeg\";}', '1', '2019-03-01 07:04:15', '2019-03-01 07:04:15', '0'), ('74', '1', 'a:4:{i:0;s:26:\"/upload//5c7d85f9b2da3.png\";i:1;s:26:\"/upload//5c7d85fc157ef.png\";i:2;s:26:\"/upload//5c7d85fc54bc7.png\";i:3;s:26:\"/upload//5c7d85fce6b95.png\";}', '1', '2019-03-05 04:10:21', '2019-03-05 04:10:21', '0'), ('75', '1', 'a:4:{i:0;s:26:\"/upload//5c7d8bf5223b7.png\";i:1;s:26:\"/upload//5c7d8bf5d541f.png\";i:2;s:26:\"/upload//5c7d8bf5ebbfc.png\";i:3;s:26:\"/upload//5c7d8bf602383.png\";}', '1', '2019-03-05 04:35:02', '2019-03-05 04:35:02', '0'), ('76', '1', 'a:5:{i:0;s:26:\"/upload//5c7d8c093b79c.png\";i:1;s:26:\"/upload//5c7d8c0963766.png\";i:2;s:26:\"/upload//5c7d8c098cccd.png\";i:3;s:26:\"/upload//5c7d8c09a7a34.png\";i:4;s:26:\"/upload//5c7d8c0a9717e.png\";}', '1', '2019-03-05 04:35:24', '2019-03-05 04:35:24', '0'), ('77', '1', 'a:1:{i:0;s:26:\"/upload//5c7d8ce3e8391.png\";}', '1', '2019-03-05 04:39:01', '2019-03-05 04:39:01', '0'), ('78', '1', 'a:3:{i:0;s:26:\"/upload//5c7d97989a619.jpg\";i:1;s:26:\"/upload//5c7d97989fcf3.jpg\";i:2;s:26:\"/upload//5c7d9798a4136.jpg\";}', '1', '2019-03-05 05:24:45', '2019-03-05 05:24:45', '0'), ('79', '1', 'a:4:{i:0;s:26:\"/upload//5c7d98628b399.jpg\";i:1;s:26:\"/upload//5c7d98628d5f8.jpg\";i:2;s:26:\"/upload//5c7d98628f73e.jpg\";i:3;s:26:\"/upload//5c7d9862918b3.jpg\";}', '1', '2019-03-05 05:28:05', '2019-03-05 05:28:05', '0'), ('80', '1', 'a:3:{i:0;s:26:\"/upload//5c7d98c2977e8.jpg\";i:1;s:26:\"/upload//5c7d98c29ba4c.jpg\";i:2;s:26:\"/upload//5c7d98c29ee3f.jpg\";}', '1', '2019-03-05 05:29:42', '2019-03-05 05:29:42', '0'), ('81', '1', 'a:3:{i:0;s:26:\"/upload//5c7d9becaa792.jpg\";i:1;s:26:\"/upload//5c7d9becae79d.jpg\";i:2;s:26:\"/upload//5c7d9becb09f7.jpg\";}', '1', '2019-03-05 05:43:31', '2019-03-05 05:43:31', '0'), ('82', '1', 'a:4:{i:0;s:26:\"/upload//5c7d9c354bc6a.jpg\";i:1;s:26:\"/upload//5c7d9c355724e.jpg\";i:2;s:26:\"/upload//5c7d9c355931f.jpg\";i:3;s:26:\"/upload//5c7d9c355cc5f.jpg\";}', '1', '2019-03-05 05:44:22', '2019-03-05 05:44:22', '0'), ('83', '1', 'a:3:{i:0;s:26:\"/upload//5c7d9c5e199af.jpg\";i:1;s:26:\"/upload//5c7d9c5e1ded8.jpg\";i:2;s:26:\"/upload//5c7d9c5e20f6a.jpg\";}', '1', '2019-03-05 05:45:04', '2019-03-05 05:45:04', '0'), ('84', '1', 'a:5:{i:0;s:26:\"/upload//5c7d9c8c2f34d.png\";i:1;s:26:\"/upload//5c7d9c8cdb5d1.png\";i:2;s:26:\"/upload//5c7d9c8ce1275.png\";i:3;s:26:\"/upload//5c7d9c8cf0fd2.png\";i:4;s:26:\"/upload//5c7d9c8d08592.png\";}', '1', '2019-03-05 05:45:49', '2019-03-05 05:45:49', '0'), ('85', '1', 'a:3:{i:0;s:26:\"/upload//5c7d9c9407fbd.jpg\";i:1;s:26:\"/upload//5c7d9c940a0bb.jpg\";i:2;s:26:\"/upload//5c7d9c940c1ee.jpg\";}', '1', '2019-03-05 05:45:57', '2019-03-05 05:45:57', '0'), ('86', '1', 'a:3:{i:0;s:26:\"/upload//5c7d9cc79428d.jpg\";i:1;s:26:\"/upload//5c7d9cc7982ac.jpg\";i:2;s:26:\"/upload//5c7d9cc79ae9a.jpg\";}', '1', '2019-03-05 05:46:49', '2019-03-05 05:46:49', '0'), ('87', '1', 'a:3:{i:0;s:26:\"/upload//5c7d9cdf6397e.jpg\";i:1;s:26:\"/upload//5c7d9cdf68401.jpg\";i:2;s:26:\"/upload//5c7d9cdf6c08a.jpg\";}', '1', '2019-03-05 05:47:12', '2019-03-05 05:47:12', '0'), ('97', '0', 'a:1:{i:0;s:13:\"/upload/3.png\";}', '1', '2019-10-08 12:42:33', '2019-10-08 12:42:33', '0'), ('98', '1', 'a:2:{i:0;s:13:\"/upload/4.png\";i:1;s:13:\"/upload/5.jpg\";}', '1', '2019-10-08 13:25:42', '2019-10-08 13:25:42', '0'), ('99', '1', 'a:2:{i:0;s:13:\"/upload/4.png\";i:1;s:13:\"/upload/5.jpg\";}', '1', '2019-10-08 13:26:06', '2019-10-08 13:26:06', '0'), ('100', '0', 'a:4:{i:0;s:13:\"/upload/1.png\";i:1;s:6:\"/2.png\";i:2;s:31:\"/upload/posts/5db60e3db6091.jpg\";i:3;s:31:\"/upload/posts/5db60e45c6d11.png\";}', '1', '2019-10-08 12:26:57', '2019-10-08 12:26:57', '0'), ('101', '3', 'a:3:{i:0;s:7:\"sdfsdlj\";i:1;s:8:\"jflsdjfl\";i:2;s:3:\"sdf\";}', '1', '2020-05-01 17:20:25', '2020-05-01 17:20:25', '0'), ('102', '3', 'a:3:{i:0;s:7:\"sdfsdlj\";i:1;s:8:\"jflsdjfl\";i:2;s:3:\"sdf\";}', '1', '2020-05-01 17:20:58', '2020-05-01 17:20:58', '0'), ('103', '3', 'a:3:{i:0;s:7:\"sdfsdlj\";i:1;s:8:\"jflsdjfl\";i:2;s:3:\"sdf\";}', '1', '2020-05-01 17:28:31', '2020-05-01 17:28:31', '0'), ('104', '3', 'a:3:{i:0;s:7:\"sdfsdlj\";i:1;s:8:\"jflsdjfl\";i:2;s:3:\"sdf\";}', '1', '2020-05-01 20:51:15', '2020-05-01 20:51:15', '0'), ('105', '3', 'a:3:{i:0;s:7:\"sdfsdlj\";i:1;s:8:\"jflsdjfl\";i:2;s:3:\"sdf\";}', '1', '2020-05-01 20:52:07', '2020-05-01 20:52:07', '0');
COMMIT;

-- ----------------------------
--  Table structure for `alibabaactivity`
-- ----------------------------
DROP TABLE IF EXISTS `alibabaactivity`;
CREATE TABLE `alibabaactivity` (
  `activity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '1688促销活动编号',
  `activity_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '1688促销活动标题',
  `hot_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '预热时间',
  `start_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '开始时间',
  `end_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '结束时间',
  PRIMARY KEY (`activity_id`),
  UNIQUE KEY `activity_id` (`activity_id`) USING BTREE,
  KEY `activity_name` (`activity_name`) USING BTREE,
  KEY `start_time` (`start_time`) USING BTREE,
  KEY `end_time` (`end_time`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='1688促销活动';

-- ----------------------------
--  Records of `alibabaactivity`
-- ----------------------------
BEGIN;
INSERT INTO `alibabaactivity` VALUES ('11', '活动名称', '2020-02-10 00:00:00', '2020-03-10 00:00:00', '2020-04-10 00:00:00');
COMMIT;

-- ----------------------------
--  Table structure for `alibabacategory`
-- ----------------------------
DROP TABLE IF EXISTS `alibabacategory`;
CREATE TABLE `alibabacategory` (
  `id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '1688商品分类编号',
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '商品分类名称',
  `parent` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '上级分类',
  `publishing` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否允许发布商品(0为否,1为是,默认0)',
  `min_order_quantity` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '最小起订量',
  `stats` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '状态(0为下架,1为上架,默认1)',
  `icon` varchar(255) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT 'icon',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `created_by` int(11) NOT NULL DEFAULT '0' COMMENT '创建者',
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '编辑时间',
  `updated_by` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '编辑者',
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique` (`name`) USING BTREE,
  KEY `parent` (`parent`) USING BTREE,
  KEY `publish` (`publishing`) USING BTREE,
  KEY `created_by` (`created_by`) USING BTREE,
  KEY `created_at` (`created_at`) USING BTREE,
  KEY `updated_by` (`updated_by`) USING BTREE,
  KEY `updated_at` (`updated_at`) USING BTREE,
  KEY `stats` (`stats`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='1688商品分类';

-- ----------------------------
--  Records of `alibabacategory`
-- ----------------------------
BEGIN;
INSERT INTO `alibabacategory` VALUES ('1', '农业', '0', '0', '1', '0', '0', '2020-03-20 10:53:41', '66', '2020-03-20 12:55:51', '66'), ('2', '食品酒水', '0', '0', '1', '0', '0', '2020-03-20 10:53:41', '66', '2020-03-20 12:55:52', '66'), ('4', '纺织、皮革', '0', '0', '1', '0', '0', '2020-03-20 10:53:41', '66', '2020-03-20 12:55:53', '66'), ('5', '电工电气', '0', '0', '1', '0', '0', '2020-03-20 10:53:41', '66', '2020-03-20 12:55:55', '66'), ('6', '家用电器', '0', '0', '1', '0', '0', '2020-03-20 10:53:41', '66', '2020-03-20 12:55:56', '66'), ('7', '数码、电脑', '0', '0', '1', '0', '0', '2020-03-20 10:53:41', '66', '2020-03-20 12:55:58', '66'), ('8', '化工', '0', '0', '1', '0', '0', '2020-03-20 10:53:41', '66', '2020-03-20 12:55:59', '66'), ('9', '冶金矿产', '0', '0', '1', '0', '0', '2020-03-20 10:53:41', '66', '2020-03-20 12:56:00', '66'), ('10', '能源', '0', '0', '1', '0', '0', '2020-03-20 10:53:41', '66', '2020-03-20 12:56:01', '66'), ('12', '交通运输', '0', '0', '1', '0', '0', '2020-03-20 10:53:41', '66', '2020-03-20 12:56:03', '66'), ('13', '家装、建材', '0', '0', '1', '0', '0', '2020-03-20 10:53:41', '66', '2020-03-20 12:56:04', '66'), ('15', '日用百货', '0', '0', '1', '0', '0', '2020-03-20 10:53:41', '66', '2020-03-20 12:56:07', '66'), ('17', '工艺品、礼品', '0', '0', '1', '0', '0', '2020-03-20 10:53:41', '66', '2020-03-20 12:56:09', '66'), ('18', '运动户外', '0', '0', '1', '0', '0', '2020-03-20 10:53:41', '66', '2020-03-20 12:56:10', '66'), ('53', '传媒、广电', '0', '0', '1', '0', '0', '2020-03-20 10:53:41', '66', '2020-03-20 12:56:11', '66'), ('54', '服饰配件、饰品', '0', '0', '1', '0', '0', '2020-03-20 10:53:41', '66', '2020-03-20 12:56:13', '66'), ('55', '橡塑', '0', '0', '1', '0', '0', '2020-03-20 10:53:41', '66', '2020-03-20 12:56:15', '66'), ('57', '电子元器件', '0', '0', '1', '0', '0', '2020-03-20 10:53:41', '66', '2020-03-20 12:56:16', '66'), ('58', '灯饰照明', '0', '0', '1', '0', '0', '2020-03-20 10:53:41', '66', '2020-03-20 12:56:17', '66'), ('59', '五金、工具', '0', '0', '1', '0', '0', '2020-03-20 10:53:41', '66', '2020-03-20 12:56:24', '66'), ('64', '环保', '0', '0', '1', '0', '0', '2020-03-20 10:53:41', '66', '2020-03-20 12:56:24', '66'), ('65', '机械及行业设备', '0', '0', '1', '0', '0', '2020-03-20 10:53:41', '66', '2020-03-20 12:56:24', '66'), ('66', '医药、保养', '0', '0', '1', '0', '0', '2020-03-20 10:53:41', '66', '2020-03-20 12:56:24', '66'), ('67', '办公、文化', '0', '0', '1', '0', '0', '2020-03-20 10:53:41', '66', '2020-03-20 12:56:24', '66'), ('68', '包装', '0', '0', '1', '0', '0', '2020-03-20 10:53:41', '66', '2020-03-20 12:56:24', '66'), ('69', '商务服务', '0', '0', '1', '0', '0', '2020-03-20 10:53:41', '66', '2020-03-20 12:56:24', '66'), ('70', '安全、防护', '0', '0', '1', '0', '0', '2020-03-20 10:53:41', '66', '2020-03-20 12:56:24', '66'), ('71', '汽摩及配件', '0', '0', '1', '0', '0', '2020-03-20 10:53:41', '66', '2020-03-20 12:56:24', '66'), ('72', '印刷', '0', '0', '1', '0', '0', '2020-03-20 10:53:41', '66', '2020-03-20 12:56:24', '66'), ('96', '家纺家饰', '0', '0', '1', '0', '0', '2020-03-20 10:53:41', '66', '2020-03-20 12:56:24', '66'), ('97', '美容护肤/彩妆', '0', '0', '1', '1', '/upload/category_icon/5eb8aed6a46d8.png', '2020-03-20 10:53:41', '66', '2020-05-11 09:48:09', '66'), ('303', '棉衣', '127420001', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('304', '皮草', '10166', '1', '1', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('305', '旗袍', '125740002', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('309', '工作制服', '125730002', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('311', '童装', '0', '0', '1', '0', '0', '2020-03-20 10:53:41', '66', '2020-03-20 12:56:24', '66'), ('312', '内衣', '0', '0', '1', '0', '0', '2020-03-20 10:53:41', '66', '2020-03-20 12:56:24', '66'), ('319', '女式风衣', '10166', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('320', '婚纱', '125740002', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('346', '舞台服、表演服', '125730002', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:16', '0'), ('509', '通信产品', '0', '0', '1', '0', '0', '2020-03-20 10:53:41', '66', '2020-03-20 12:56:24', '66'), ('1426', '机床', '0', '0', '1', '0', '0', '2020-03-20 10:53:41', '66', '2020-03-20 12:56:24', '66'), ('1501', '母婴用品', '0', '0', '1', '0', '0', '2020-03-20 10:53:41', '66', '2020-03-20 12:56:24', '66'), ('1813', '玩具', '0', '0', '1', '0', '0', '2020-03-20 10:53:41', '66', '2020-03-20 12:56:24', '66'), ('2805', '加工', '0', '0', '1', '0', '0', '2020-03-20 10:53:41', '66', '2020-03-20 12:56:24', '66'), ('2829', '二手设备转让', '0', '0', '1', '0', '0', '2020-03-20 10:53:41', '66', '2020-03-20 12:56:24', '66'), ('10163', '毛衣', '125746001', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:14', '0'), ('10165', '男装', '0', '0', '1', '0', '0', '2020-03-20 10:53:41', '66', '2020-03-20 12:56:24', '66'), ('10166', '女装', '0', '0', '1', '1', '/upload/category_icon/5eb8ae514e51e.png', '2020-03-20 10:53:41', '66', '2020-05-11 09:46:06', '66'), ('10208', '仪器仪表', '0', '0', '1', '0', '0', '2020-03-20 10:53:41', '66', '2020-03-20 12:56:24', '66'), ('82101', '面部彩妆', '97', '0', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('82105', '女士香水', '201303115', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('290303', '服装项目合作', '10166', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:12', '0'), ('1031792', '女装代理加盟', '125750001', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:07', '0'), ('1031869', '女式牛仔裤', '10166', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:06', '0'), ('1031871', '休闲裤', '125748001', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:05', '0'), ('1031910', '连衣裙', '10166', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:04:53', '0'), ('1031912', '半身裙', '10166', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:04:57', '0'), ('1031917', '其他短外套', '10166', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:04:59', '0'), ('1031918', '女式衬衫', '10166', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:00', '0'), ('1031919', '女式T恤', '10166', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:01', '0'), ('1031920', '小背心/吊带/抹胸', '10166', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:02', '0'), ('1034162', '羽绒服', '127360010', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:04', '0'), ('1034565', '纤体膏/霜', '126182004', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1034566', '胸部护理', '126182004', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1034755', '其他面部护肤品', '1042634', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1034758', '护手霜', '126182004', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1034761', '防晒霜、防晒喷雾', '1042634', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1034762', '乳液、凝露、啫哩', '1042634', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1034763', '面霜', '1042634', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1034765', '贴片面膜', '201308710', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1034766', '化妆水、爽肤水', '1042634', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1034770', '剃须膏、须后水', '121702001', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1034778', '其他彩妆', '82101', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1034779', '眉笔、眉粉、眉膏', '201307604', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1034780', '睫毛膏、睫毛增长液', '201307604', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1034781', '指甲油、护甲油', '1043162', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1034782', '眼影', '201307604', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1034783', '口红', '201304705', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1034784', '腮红、胭脂', '82101', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1034785', '粉底', '82101', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1036617', '女式马甲', '10166', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('1036807', '面部护理套装', '1042634', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1036812', '眼线', '201307604', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1037013', '学生校服', '125730002', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('1037019', '女式皮衣', '10166', '1', '1', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('1037020', '小西装', '10166', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('1037021', '女式卫衣、绒衫', '10166', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('1037024', '打底裤', '127380008', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('1037038', '情侣装', '125730002', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('1040898', '粉饼', '82101', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1040900', '蜜粉、散粉、定妆粉', '82101', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1041576', '复方精油', '201309707', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1041750', '卸妆水/乳/油', '1042634', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1042634', '面部护理', '97', '0', '1', '1', '0', '2020-03-20 10:53:41', '66', '2020-03-20 12:56:40', '66'), ('1042655', '洁面产品', '1042634', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1042950', '美容代理加盟', '97', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1043070', '身体乳、霜', '126182004', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1043093', 'BB霜', '82101', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1043094', '彩妆套装、彩妆盘', '82101', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1043095', '遮瑕', '82101', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1043143', '美发梳', '1043171', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1043144', '美发剪', '1043171', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1043145', '卷发球、发卷', '1043171', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1043162', '美甲产品', '97', '0', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1043163', '指甲剪、钳、刀', '1043162', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1043164', '指甲锉', '1043162', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1043165', '指甲刷', '1043162', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1043166', '甲片', '1043162', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1043167', '美甲饰品', '1043162', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1043168', '美甲工具套装', '1043162', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1043169', '美甲机、光疗灯', '1043162', '1', '2', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1043170', '其他美甲产品', '1043162', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1043171', '美妆工具', '97', '0', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1043174', '假睫毛', '1043171', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1043175', '双眼皮贴、胶水', '1043171', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1043176', '睫毛夹、烫睫毛器', '1043171', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1043177', '眉刀、眉剪、眉夹', '1043171', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1043178', '粉刺针、暗疮针、黑头夹', '1043171', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1043179', '粉扑、美妆蛋', '1043171', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1043181', '面膜纸、棒、碗', '1043171', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1043183', '化妆棉、棉签', '1043171', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1043184', '化妆刷、刷包', '1043171', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1043185', '吸油面纸', '1043171', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1043188', '化妆工具套装', '1043171', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1043189', '其他美妆工具', '1043171', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1043433', '液态精华', '201308310', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1043434', '面部按摩霜、乳', '1042634', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1043435', '面部磨砂、去角质', '1042634', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1043436', '鼻贴、鼻膜', '1042634', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1043498', '唇部护理', '97', '0', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1043499', '唇膏、唇油', '1043498', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1043500', '唇膜、唇霜', '1043498', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1043502', '其他唇部护理产品', '1043498', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1043504', '唇笔、唇线笔', '201304705', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1044067', '面部护理加工定制', '125070013', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1046799', '大码连衣裙', '127372010', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('1046800', '中老年女装', '10166', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('1046942', '隔离/妆前', '82101', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1046969', '颈部护理', '126182004', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('1048182', '蕾丝衫、雪纺衫', '10166', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('1048184', '职业女裙套装', '125730002', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('1048256', '时尚休闲套装', '10166', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('1048316', '羽绒裤/棉裤', '125748001', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('121694002', '男士面部精华', '121702001', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('121702001', '男士护肤', '97', '0', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('121706001', '男士洁面', '121702001', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('121708001', '男士爽肤水', '121702001', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('121708002', '眼膜', '201303117', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('121710001', '男士乳液', '121702001', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('121710002', '男士面膜', '121702001', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('121712001', '男士眼霜', '121702001', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('121714001', '男士润唇膏', '121702001', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('122204004', '其他身体护理用品', '126182004', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('122310013', '男士面部护理套装', '121702001', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('122364006', '男士身体护理', '121702001', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('122668001', '洁面仪、洁面刷', '201307015', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('122668006', '女装杂款包', '125750001', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('122708002', '手工皂', '1042634', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('123646004', '仪器可导入原液', '123650003', '1', '2', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('123650003', '专业线护肤', '97', '0', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('123650004', '冻干粉', '123650003', '1', '2', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('123666002', '花水纯露', '201309707', '1', '2', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('123666003', '美容胶囊', '123650003', '1', '2', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('123696002', '瘦脸工具', '201307015', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('123696003', '美眼仪', '201307015', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('123698002', '美容导入仪', '201307015', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('123702001', '美容棒', '201307015', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('123854001', '单方精油', '201309707', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('124150002', '甲油胶', '1043162', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('124152004', '女式羊绒衫', '125746001', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('124154003', '女式貂绒衫', '125746001', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('124160003', '女式羊毛衫', '125746001', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('124186007', '美甲笔', '1043162', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('124256002', '卸甲用品', '1043162', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('124774001', '基底精油', '201309707', '1', '2', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('124824007', '专业线护肤加工定制', '125070013', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('125062022', '美妆工具加工定制', '125070013', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('125070013', '美妆日化加工', '97', '0', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('125070014', '面膜加工定制', '125070013', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('125420001', '女式毛呢外套', '10166', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('125730002', '情侣/制服/表演服', '10166', '0', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 15:25:33', '0'), ('125740002', '婚纱/礼服/旗袍', '10166', '0', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 15:25:21', '0'), ('125746001', '女式毛衣', '10166', '0', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 15:25:20', '0'), ('125748001', '女式休闲裤', '10166', '0', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 15:25:19', '0'), ('125750001', '女装杂款', '10166', '0', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 15:25:18', '0'), ('125750002', '女式夹克/棒球服', '10166', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('125752002', '西装裤/正装裤', '125748001', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('126136006', '纹绣产品', '126182004', '1', '2', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('126182004', '身体护理', '97', '0', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('127184002', '女装加工定制', '10166', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('127340007', '大码棉服', '127372010', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('127342011', '大码风衣', '127372010', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('127348009', '大码马甲', '127372010', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('127348010', '大码皮草', '127372010', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('127350007', '大码夹克/棒球服', '127372010', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('127352008', '大码皮衣', '127372010', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('127354007', '大码羽绒服', '127372010', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('127354008', '大码打底裤', '127372010', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('127356010', '大码T恤', '127372010', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('127356011', '大码蕾丝衫、雪纺', '127372010', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('127360007', '大码其他女式上装', '127372010', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('127360008', '大码外套', '127372010', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('127360010', '女式羽绒服', '10166', '0', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 15:25:16', '0'), ('127362011', '大码卫衣、绒衣', '127372010', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('127364007', '大码西装', '127372010', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('127364008', '大码针织衫', '127372010', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('127364009', '一体裤', '127380008', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('127366007', '大码毛衣', '127372010', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('127370007', '大码时尚休闲套装', '127372010', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('127372010', '大码女装', '10166', '0', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 15:24:51', '0'), ('127372011', '大码小背心/吊带/抹胸', '127372010', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('127374009', '羽绒背心', '127360010', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('127376007', '大码休闲裤', '127372010', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('127376008', '大码其他女式裤装', '127372010', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('127380006', '大码毛呢外套', '127372010', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('127380007', '大码牛仔裤', '127372010', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('127380008', '女式打底裤', '10166', '0', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 15:24:55', '0'), ('127382007', '大码衬衫', '127372010', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('127384002', '大码半身裙', '127372010', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('127386001', '女式针织衫', '10166', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('127420001', '女式棉衣', '10166', '0', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 15:24:58', '0'), ('127422001', '棉服背心', '127420001', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('201156304', '礼服/晚装', '125740002', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('201156902', '其他民族女装', '201158403', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('201158403', '女式民族服装', '10166', '0', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 15:25:01', '0'), ('201159103', '汉服/禅茶服/禅舞服', '201158403', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('201159503', '女式唐装', '201158403', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('201159905', '穆斯林女装', '201158403', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('201160003', '秀禾服', '125740002', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('201160604', '动漫角色扮演服', '125730002', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('201162003', '职业女裤套装', '125730002', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('201217707', '二次元动漫服装/配件', '10166', '0', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 15:25:09', '0'), ('201218111', '动漫人物角色服装/配件', '201217707', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('201222619', '修容', '82101', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201228007', '卡通人偶服装/配件', '201217707', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('201230506', '洛丽塔Lolita服/配件', '201217707', '1', '2', '1', '0', '2020-03-26 11:54:02', '0', '2020-03-26 12:05:49', '0'), ('201270664', '洗脸扑', '1043171', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201301111', '粉状精华', '201308310', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201301310', '美甲贴', '1043162', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201301632', '精油芳疗加工定制', '125070013', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201302015', '身体磨砂、去角质', '126182004', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201302408', '纹身工具', '201307015', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201302512', '院线护理套盒', '123650003', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201302810', '其他香水', '201303115', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201303115', '香水', '97', '0', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201303117', '眼部护理', '97', '0', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201304311', '其它精油芳疗产品', '201309707', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201304511', '唇部护理套装', '1043498', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201304512', '男士彩妆', '82101', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201304705', '唇部彩妆', '97', '0', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201304821', '香水加工定制', '125070013', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201305009', '涂抹面膜', '201308710', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201305210', '其他专业线护肤品', '123650003', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201305309', '中性香水', '201303115', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201305507', '身体护理加工定制', '125070013', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201306109', '面膜粉', '201308710', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201306409', '唇部精华、啫喱', '1043498', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201306522', '彩妆加工定制', '125070013', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201306608', '唇釉', '201304705', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201306711', '粉扑清洁液', '1043171', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201306811', '眼霜', '201303117', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201306907', '精油皂', '201309707', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201307005', '其它足部护理', '126182004', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201307015', '美容仪器', '97', '0', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201307110', '护足霜', '126182004', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201307111', '足膜', '126182004', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201307309', '手膜', '126182004', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201307407', '画眉、修眉套装', '1043171', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201307604', '眼部彩妆', '97', '0', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201307708', '安瓶、原液', '201308310', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201308310', '面部精华', '97', '0', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201308311', '唇蜜', '201304705', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201308508', '男士香水', '201303115', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201308710', '面膜、面膜粉', '97', '0', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201308806', '手部磨砂、去角质', '126182004', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201308904', '眼部精华', '201303117', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201309020', '美甲产品加工定制', '125070013', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201309107', '面膜套装', '201308710', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201309108', 'T区护理套装', '1042634', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201309210', '唇部磨砂', '1043498', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201309512', '唇部护理加工定制', '125070013', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201309513', '固体香膏', '201303115', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201309707', '精油芳疗', '97', '0', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201309708', '眼部护理套装', '201303117', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201309831', '面部精华加工定制', '125070013', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201310003', '美睫胶', '1043171', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201310022', '眼部护理加工定制', '125070013', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201310107', '足部磨砂、去角质', '126182004', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201310409', '黑头导出液', '1042634', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201310505', '唇彩', '201304705', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66'), ('201310903', '卸妆巾、卸妆湿巾', '1043171', '1', '3', '1', '0', '2020-03-20 12:10:11', '66', '2020-03-20 12:55:41', '66');
COMMIT;

-- ----------------------------
--  Table structure for `alibabafavour`
-- ----------------------------
DROP TABLE IF EXISTS `alibabafavour`;
CREATE TABLE `alibabafavour` (
  `product_id` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '1688商品编号',
  `member_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '会员',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '收藏时间',
  PRIMARY KEY (`product_id`,`member_id`),
  UNIQUE KEY `unique` (`product_id`,`member_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='1688商品收藏';

-- ----------------------------
--  Records of `alibabafavour`
-- ----------------------------
BEGIN;
INSERT INTO `alibabafavour` VALUES ('584051070147', '6', '2020-03-31 16:37:26');
COMMIT;

-- ----------------------------
--  Table structure for `alibabaproduct`
-- ----------------------------
DROP TABLE IF EXISTS `alibabaproduct`;
CREATE TABLE `alibabaproduct` (
  `product_id` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '584051070147',
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '商品分类',
  `title` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '商品标题',
  `price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '原价',
  `promotion_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '超买价',
  `img_url` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '商品首图',
  `images` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '主图列表(使用相对路径,需要增加域名:https://cbu01.alicdn.com/)',
  `channel_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '渠道专属价',
  `sales` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '销量',
  `reference_price` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '参考价格(返回价格区间,可能为空)',
  `supplier_login_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '供应商loginId',
  `main_video` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '主图视频播放地址',
  `product_cargo_number` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '商品货号(产品属性中的货号)',
  `alibaba_stats` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '1688商品状态(published:上网状态,member expired:会员撤销,auto expired:自然过期,expired:过期(包含手动过期与自动过期),member deleted:会员删除,modified:修改,new:新发,deleted:删除,TBD:to be delete,approved:审批通过,auditing:审核中,untread:审核不通过)',
  `stats` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '状态',
  `redemption` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '允许积分兑换(0为否,1为是,2为即能积分兑换又能销售,默认0)',
  `integral` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '兑换所需积分',
  `quality_level` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '质量星级(0-5)',
  `support_online_trade` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '是否支持网上交易(1为支持,0为不支持,默认1)',
  `mix_whole_sale` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '是否支持混批(0为否,1为是,默认1)',
  `price_auth` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否价格私密信息(1为是,0为否,默认1)',
  `price_ranges` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '价格区间json字符串',
  `amount_on_sale` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '可售数量',
  `unit` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '记件单位',
  `min_order_quantity` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '最小起订量，范围是1-99999',
  `batch_number` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '每批数量，默认为空或者非零值，该属性不为空时sellunit为必填',
  `sell_unit` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '售卖单位，如果为批量售卖，代表售卖的单位，该属性不为空时batch_number为必填，例如1''手''=12''件''的''手''',
  `quote_type` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '0-无SKU按数量报价,1-有SKU按规格报价,2-有SKU按数量报价',
  `consign_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '分销基准价。代销场景均使用该价格。有SKU商品查看skuInfo中的consignPrice',
  `cps_suggest_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT 'CPS建议价（单位：元)',
  `platform_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '平台售价',
  `recommennd` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否推荐(0为否,1为是,默认0)',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`product_id`),
  UNIQUE KEY `product_id` (`product_id`) USING BTREE,
  KEY `title` (`title`) USING BTREE,
  KEY `price` (`price`) USING BTREE,
  KEY `promotion_price` (`promotion_price`) USING BTREE,
  KEY `channel_price` (`channel_price`) USING BTREE,
  KEY `sales` (`sales`) USING BTREE,
  KEY `category_id` (`category_id`) USING BTREE,
  KEY `stats` (`stats`) USING BTREE,
  KEY `quality_level` (`quality_level`) USING BTREE,
  KEY `recommend` (`recommennd`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='1688商品';

-- ----------------------------
--  Records of `alibabaproduct`
-- ----------------------------
BEGIN;
INSERT INTO `alibabaproduct` VALUES ('123', '0', '0', '0.00', '0.00', '0', null, '0.00', '0', '0', '0', '0', '0', '0', '0', '0', '0.00', '0', '1', '1', '0', null, '0', '0', '0', '0', '0', '1', '0.00', '0.00', '0.00', '0', '2020-03-31 16:50:15', '2020-03-31 16:50:15'), ('584051070147', '1046799', '大市场的offer', '1.10', '0.90', '/upload/product_main_image/5e8208f86ca55.png', '', '1.10', '333', '10.0', '0', '/upload/product_main_video/5e817cc414eb9.mp4', '', 'approved', '1', '1', '300.00', '0', '1', '0', '0', '[{\"price\": 10.0, \"startQuantity\": 2}, {\"price\": 5.0, \"startQuantity\": 5}]', '100', '件', '2', '0', '', '1', '35.00', '0.00', '400.00', '1', '2020-03-26 11:27:14', '2020-05-11 12:08:02');
COMMIT;

-- ----------------------------
--  Table structure for `alibabaproductactivity`
-- ----------------------------
DROP TABLE IF EXISTS `alibabaproductactivity`;
CREATE TABLE `alibabaproductactivity` (
  `product_id` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '1688商品编号',
  `activity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '活动编号',
  `begin_quantity` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '活动起批量',
  `stock` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '活动总库存，为0时使用offer原库存',
  `person_limit_count` int(11) NOT NULL DEFAULT '-1' COMMENT '商品本身限购数，非活动价可购买数；-1表示不限，0表示可购买数为0；3个*LimitCount字段都等于-1时，表示没有任何限购',
  `promotion_limit_count` int(11) NOT NULL DEFAULT '-1' COMMENT '限购数，等于0且personLimitCount>0时，可以以原价下单，但不能以活动价下单；-1表示不限数量；3个*LimitCount字段都等于-1时，表示没有任何限购',
  `activity_limit_count` int(11) NOT NULL DEFAULT '-1' COMMENT '活动限购数；该场内活动商品限购数，-1表示不限购；0表示不可购买该场活动所有商品；3个*LimitCount字段都等于-1时，表示没有任何限购',
  `free_postage_start_time` datetime DEFAULT NULL COMMENT '活动限时包邮开始时间；null 表示不限时',
  `free_postage_end_time` datetime DEFAULT NULL COMMENT '活动限时包邮结束时间；null 表示不限时',
  `exclude_area_list` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '免包邮地区，与活动包邮配合使用',
  `range_price` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '如果offer是范围报价，且价格优惠是折扣的情况，返回折扣计算后的价格范围;优先取该字段，该字段为空时，表示分sku报价，取promotionItemList',
  `promotion_item_list` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '优惠结果，根据优惠方式（PromotionInfo），结合offer的原价信息，计算出优惠结果：每个sku或者每个区间价的促销价，折扣率',
  `sku_stock_list` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'sku维度的库存结果',
  `intro_order_flow` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '这里平台会计算一个推荐使用的下单flow，可以用这个flow值调用下单接口',
  PRIMARY KEY (`product_id`,`activity_id`),
  UNIQUE KEY `unique` (`product_id`,`activity_id`) USING BTREE,
  KEY `product_id` (`product_id`) USING BTREE,
  KEY `activity_id` (`activity_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='1688商品活动';

-- ----------------------------
--  Table structure for `alibabashipping`
-- ----------------------------
DROP TABLE IF EXISTS `alibabashipping`;
CREATE TABLE `alibabashipping` (
  `product_id` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '1688商品编号',
  `freight_template_id` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '运费模板ID(0为运费说明,1为卖家承担运费,其他值表示使用运费模版)',
  `unit_weight` double unsigned NOT NULL DEFAULT '0' COMMENT '重量/毛重',
  `send_goods_address_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '发货地址ID',
  `send_goods_address_text` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '发货地描述',
  `suttle_weight` double unsigned NOT NULL DEFAULT '0' COMMENT '净重',
  `height` double unsigned NOT NULL DEFAULT '0' COMMENT '高度',
  `width` double unsigned NOT NULL DEFAULT '0' COMMENT '宽度',
  `length` double unsigned NOT NULL DEFAULT '0' COMMENT '长度',
  `channel_price_free_postage` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '厂货通渠道专享价是否包邮，要结合非包邮地址，如果收货地址在非包邮地区则商品为不包邮',
  `channel_price_exclude_areaCodes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '厂货通渠道专享价非包邮地区（地址信息列表，省份信息',
  PRIMARY KEY (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='1688商品物流信息';

-- ----------------------------
--  Records of `alibabashipping`
-- ----------------------------
BEGIN;
INSERT INTO `alibabashipping` VALUES ('584051070147', '1', '0', '14346579', '青海省 果洛藏族自治州', '0', '0', '0', '0', '0', '');
COMMIT;

-- ----------------------------
--  Table structure for `alibabasku`
-- ----------------------------
DROP TABLE IF EXISTS `alibabasku`;
CREATE TABLE `alibabasku` (
  `sku_id` varchar(13) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '阿里巴巴skuId',
  `product_id` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '阿里巴巴产品编号',
  `spec_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '该规格在本商品内的唯一标记',
  `cargo_number` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '指定规格的货号',
  `amount_on_sale` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '可销售数量',
  `retail_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '建议零售价',
  `price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '报价时该规格的单价',
  `consign_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '分销基准价。代销场景均使用该价格。无SKU商品查看saleInfo中的consignPrice',
  `attribute_id` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT 'attribute_id。多个用半角逗号间隔',
  `sku_image_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT 'sku图片名',
  PRIMARY KEY (`sku_id`),
  UNIQUE KEY `sku_id` (`sku_id`) USING BTREE,
  KEY `product_id` (`product_id`) USING BTREE,
  KEY `spec_id` (`spec_id`) USING BTREE,
  KEY `product_unique` (`product_id`,`spec_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='1688产品sku';

-- ----------------------------
--  Records of `alibabasku`
-- ----------------------------
BEGIN;
INSERT INTO `alibabasku` VALUES ('4127294243178', '584051070147', 'af478130f6c683c4c77bb511796617d7', '', '999931', '0.00', '10.00', '10.00', '3216,450', '/upload/sku/5e8170c255760.jpg'), ('4127294243179', '584051070147', 'af478130f6c683c4c77bb511796617b8', '0', '8', '1.00', '12.00', '13.00', '3216', '/upload/sku/5e816796b0b91.png');
COMMIT;

-- ----------------------------
--  Table structure for `announce`
-- ----------------------------
DROP TABLE IF EXISTS `announce`;
CREATE TABLE `announce` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `type` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '类型(0为全部系统消息,1为会员消息)',
  `member_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '接受消息的会员',
  `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '标题',
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '内容',
  `stats` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '状态(0为不显示,1为显示,默认1)',
  `is_push` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否推送(0为否,1为是,默认0)',
  `msg_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '极光推送msg_id',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `created_by` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建人',
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `updated_by` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新者',
  PRIMARY KEY (`id`),
  KEY `title` (`title`) USING BTREE,
  KEY `created_at` (`created_at`) USING BTREE,
  KEY `updated_at` (`updated_at`) USING BTREE,
  KEY `stats` (`stats`) USING BTREE,
  KEY `member_id` (`member_id`) USING BTREE,
  KEY `type` (`type`) USING BTREE,
  KEY `is_push` (`is_push`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='消息';

-- ----------------------------
--  Records of `announce`
-- ----------------------------
BEGIN;
INSERT INTO `announce` VALUES ('2', '0', '0', '消息', '消息消息消息消息321123', '1', '0', '0', '2020-03-22 13:43:06', '66', '2020-04-01 10:39:17', '66'), ('3', '0', '0', '测试消息啊啊', '测试消息啊啊测试消息啊啊测试消息啊啊测试消息啊啊', '1', '0', '0', '2020-03-22 14:28:31', '66', '2020-05-12 08:53:27', '66'), ('4', '1', '6', '测试消息123', '测试消息123', '0', '0', '0', '2020-04-01 10:46:42', '66', '2020-04-01 10:48:21', '66'), ('5', '1', '8', '123231', '123123', '1', '0', '0', '2020-04-01 10:47:53', '66', '2020-04-02 14:25:28', '66'), ('6', '1', '6', '7777', '77777', '1', '1', '47287848113245957', '2020-04-01 10:48:08', '66', '2020-04-03 23:06:27', '66'), ('7', '1', '6', '抱歉，你在拼团中失败，商品金额将会退还到您的余额，请注意查收', '抱歉，你在拼团中失败，商品金额将会退还到您的余额，请注意查收', '1', '1', '54043256015042303', '2020-05-10 15:02:08', '0', '2020-05-10 15:02:08', '0'), ('8', '1', '6', '恭喜你，在的拼团中胜出，请等待卖家发货，请留意快递信息。', '恭喜你，在的拼团中胜出，请等待卖家发货，请留意快递信息。', '1', '1', '54043256015043228', '2020-05-10 15:02:42', '0', '2020-05-10 15:02:42', '0');
COMMIT;

-- ----------------------------
--  Table structure for `announcestats`
-- ----------------------------
DROP TABLE IF EXISTS `announcestats`;
CREATE TABLE `announcestats` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `announce_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '消息',
  `member_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '会员',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '阅读数件',
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique` (`member_id`,`announce_id`) USING BTREE,
  KEY `member_id` (`member_id`) USING BTREE,
  KEY `announce_id` (`announce_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='会员阅读记录';

-- ----------------------------
--  Records of `announcestats`
-- ----------------------------
BEGIN;
INSERT INTO `announcestats` VALUES ('6', '2', '6', '2020-04-02 14:35:47');
COMMIT;

-- ----------------------------
--  Table structure for `attribute`
-- ----------------------------
DROP TABLE IF EXISTS `attribute`;
CREATE TABLE `attribute` (
  `attribute_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'sku属性ID',
  `attribute_value` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT 'sku值内容',
  `attribute_display_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT 'sku属性ID所对应的显示名，比如颜色，尺码',
  `attribute_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT 'sku属性ID所对应的显示名，比如颜色，尺码',
  PRIMARY KEY (`attribute_id`),
  UNIQUE KEY `attribute_id` (`attribute_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='1688商品属性信息';

-- ----------------------------
--  Records of `attribute`
-- ----------------------------
BEGIN;
INSERT INTO `attribute` VALUES ('450', 'XS', '', '尺码'), ('3216', '黄色', '', '颜色');
COMMIT;

-- ----------------------------
--  Table structure for `authority`
-- ----------------------------
DROP TABLE IF EXISTS `authority`;
CREATE TABLE `authority` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `rule_id` int(10) unsigned NOT NULL COMMENT '权限',
  `role_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '角色',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=133 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='角色权限表';

-- ----------------------------
--  Records of `authority`
-- ----------------------------
BEGIN;
INSERT INTO `authority` VALUES ('68', '5', '2'), ('122', '19', '1'), ('123', '18', '1'), ('124', '17', '1'), ('125', '10', '1'), ('126', '9', '1'), ('127', '8', '1'), ('128', '6', '1'), ('129', '5', '1'), ('130', '3', '1'), ('131', '2', '1'), ('132', '1', '1');
COMMIT;

-- ----------------------------
--  Table structure for `booking`
-- ----------------------------
DROP TABLE IF EXISTS `booking`;
CREATE TABLE `booking` (
  `sn` varchar(50) NOT NULL COMMENT '订购信息编号',
  `trade_order_sn` varchar(50) NOT NULL DEFAULT '0' COMMENT '上游订单号',
  `member_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '会员编号',
  `product_id` varchar(16) NOT NULL DEFAULT '0' COMMENT '商品编号',
  `sku_id` varchar(13) NOT NULL DEFAULT '0' COMMENT '阿里巴巴skuId',
  `address_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '收货地址',
  `num` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '商品数量',
  `price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '价格',
  `stats` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '状态(0为未支付,1为已支付,2为发起退款,3为已退款,4为发起退货,5为已退货)',
  `channel` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '支付通道(0为支付宝,1为微信)',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `expired_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '过期时间',
  `refund_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '退款发起时间',
  `return_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '退货发起时间',
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后一次更新时间',
  PRIMARY KEY (`sn`),
  KEY `member_id` (`member_id`) USING BTREE,
  KEY `product_id` (`product_id`) USING BTREE,
  KEY `created_at` (`created_at`) USING BTREE,
  KEY `expired_at` (`expired_at`) USING BTREE,
  KEY `return_at` (`return_at`) USING BTREE,
  KEY `refund_at` (`refund_at`) USING BTREE,
  KEY `stats` (`stats`) USING BTREE,
  KEY `trade_order_sn` (`trade_order_sn`) USING BTREE,
  KEY `channel` (`channel`) USING BTREE,
  KEY `unique` (`trade_order_sn`,`channel`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='订购信息';

-- ----------------------------
--  Records of `booking`
-- ----------------------------
BEGIN;
INSERT INTO `booking` VALUES ('202004141851230643318735', '2016071921001003030200089909', '6', '584051070147', '4127294243179', '4', '2', '7.20', '1', '0', '2020-04-14 18:52:22', '2020-04-14 19:06:23', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2020-04-30 18:27:41'), ('202004141851230643318736', '234', '6', '584051070147', '4127294243179', '4', '2', '7.20', '2', '0', '2020-06-11 16:45:00', '2020-05-11 17:00:00', '2020-05-11 20:01:01', '0000-00-00 00:00:00', '2020-05-11 20:01:01'), ('202004141851230643318738', '345', '6', '584051070147', '4127294243179', '4', '2', '7.20', '3', '0', '2020-06-11 16:47:00', '2020-05-11 17:03:00', '2020-05-11 20:03:03', '0000-00-00 00:00:00', '2020-05-12 11:33:36'), ('202004141851230643318739', '456', '6', '584051070147', '4127294243179', '4', '2', '7.20', '5', '0', '2020-06-11 16:47:00', '2020-05-11 17:03:00', '0000-00-00 00:00:00', '2020-05-11 20:04:04', '2020-05-11 20:36:43'), ('202004141851230643318740', '567', '6', '584051070147', '4127294243179', '4', '2', '7.20', '1', '0', '2020-06-11 16:48:00', '2020-05-11 17:03:00', '2020-05-11 20:05:05', '0000-00-00 00:00:00', '2020-05-11 20:05:05'), ('202004141851230643318741', '678', '6', '584051070147', '4127294243179', '4', '2', '7.20', '4', '0', '2020-06-11 16:49:00', '2020-05-11 17:04:00', '0000-00-00 00:00:00', '2020-05-11 20:06:06', '2020-05-11 20:06:06'), ('202004141851230643318742', '789', '6', '584051070147', '4127294243179', '4', '2', '7.20', '4', '0', '2020-06-11 16:50:00', '2020-05-11 17:05:00', '0000-00-00 00:00:00', '2020-05-11 20:07:07', '2020-05-11 20:07:07'), ('202004141851230643318743', '890', '6', '584051070147', '4127294243179', '4', '2', '7.20', '4', '0', '2020-06-11 16:51:00', '2020-05-11 17:06:00', '0000-00-00 00:00:00', '2020-05-11 20:08:08', '2020-05-11 20:08:08'), ('202004142008060643363937', '123', '6', '584051070147', '4127294243179', '4', '2', '7.20', '1', '0', '2020-04-14 20:09:09', '2020-04-14 20:23:06', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2020-04-14 20:09:15'), ('202004301903000643358740', '2013112011001004330000121536', '6', '584051070147', '4127294243179', '4', '2', '7.20', '1', '0', '2020-04-30 19:06:02', '2020-04-30 19:18:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2020-04-30 19:11:20'), ('202004301911570643369232', '2013112011001004330000121537', '6', '584051070147', '4127294243179', '4', '2', '7.20', '1', '0', '2020-04-30 19:13:30', '2020-04-30 19:26:57', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2020-05-03 10:32:27'), ('202004301944540643312142', '2013112011001004330000121536', '6', '584051070147', '4127294243179', '4', '2', '7.20', '3', '0', '2020-04-30 19:45:07', '2020-04-30 19:59:54', '2020-04-30 20:00:04', '0000-00-00 00:00:00', '2020-04-30 22:58:23');
COMMIT;

-- ----------------------------
--  Table structure for `member`
-- ----------------------------
DROP TABLE IF EXISTS `member`;
CREATE TABLE `member` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `uuid` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '0' COMMENT 'uuid',
  `mobile` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '0' COMMENT '手机号码',
  `nickname` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '0' COMMENT '昵称',
  `password` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '密码',
  `avatar` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '0' COMMENT '头像url',
  `parent` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '上级用户',
  `device_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '0' COMMENT '设备号',
  `registration_id` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '极光推送',
  `device_type` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '设备类型(1为IOS,2为Android,默认为1)',
  `stats` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT '用户状态(0为禁止登陆,1为允许登陆,2为第三方登录后再与未绑定过第三方账号的手机登录账号进行绑定的作废账号,默认1)',
  `coupon_amount` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '拼团订单成功总金额',
  `tb_amount` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '淘宝订单金额',
  `integral` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '积分',
  `balance` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '可提现余额',
  `withdraw` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '提现金额',
  `coupon_platform_income` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '该用户通过拼团给平台创造的收入',
  `direct` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '直属好友数',
  `indirect` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '间接好友数',
  `coupon_order_number` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '拼团订单数',
  `return_order_number` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '退货订单数',
  `refund_order_number` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '退款订单数',
  `login_times` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '登陆次数',
  `last_login_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '上次登陆时间',
  `last_login_ip` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '0' COMMENT '上次登陆所使用的ip',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '注册时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uuid` (`uuid`) USING BTREE,
  KEY `nickname` (`nickname`) USING BTREE,
  KEY `stats` (`stats`) USING BTREE,
  KEY `coupon_amount` (`coupon_amount`) USING BTREE,
  KEY `tb_amount` (`tb_amount`) USING BTREE,
  KEY `balance` (`balance`) USING BTREE,
  KEY `withdraw` (`withdraw`) USING BTREE,
  KEY `coupon_platform_income` (`coupon_platform_income`) USING BTREE,
  KEY `direct` (`direct`) USING BTREE,
  KEY `indirect` (`indirect`) USING BTREE,
  KEY `coupon_order_num` (`coupon_order_number`) USING BTREE,
  KEY `return_order_num` (`return_order_number`) USING BTREE,
  KEY `refund_order_num` (`refund_order_number`) USING BTREE,
  KEY `mobile` (`mobile`) USING BTREE,
  KEY `parent` (`parent`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用户';

-- ----------------------------
--  Records of `member`
-- ----------------------------
BEGIN;
INSERT INTO `member` VALUES ('6', '646jyxypo55dezmr', '13779957421', 'hsu', '$P$Buc.0E2G48imf5r77aICVTTNPyejBZ1', '', '0', '', '18071adc0391f3ef461', '2', '1', '0.00', '0.00', '190.00', '395.20', '0.00', '0.00', '1', '1', '0', '0', '0', '74', '2020-05-13 12:35:41', '127.0.0.1', '2020-03-18 11:35:36'), ('8', 'qww9b2e101p3rr50', '13333333333', '666', '$P$BzPsyekZdc/.mp3of3O6dmygz1MBu11', '/upload/avatar/8.png', '6', '', '321', '1', '1', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '1', '0', '0', '0', '0', '8', '2020-03-18 17:18:53', '127.0.0.1', '2020-03-18 11:35:36'), ('11', 'qww9b2e19oj49w3r', '13333333334', '', '$P$BGq4Q4RV9LMkIQK//wvpEzCl40WOY2/', '', '8', '', '1', '1', '1', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0', '0', '0', '0', '0', '0', '2020-03-18 12:39:20', '127.0.0.1', '2020-03-18 11:35:36'), ('25', 'o509453mymn50jmpyeyd5jo40e216x5r55pereey36o01ykxn94nj', '0', '墙壁不要刷白色', '', 'http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eooonjhIsfOIr4rniaap3FSoUNNWKrNdw1oppsEsibO5feOiamicPj71U213MHJUa9VzslkQtQ1yibRyRg/132', '0', '', '', '1', '1', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0', '0', '0', '0', '0', '0', '2020-05-06 10:33:22', '127.0.0.1', '2020-05-06 10:33:22'), ('28', 'ko6v0nx62z01pl1e', '18906001094', '敲尼玛', '', 'http://qzapp.qlogo.cn/qzapp/101870937/3A46C2DE9357286417C03AA58DC25A1A/30', '0', '', '', '1', '1', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0', '0', '0', '0', '0', '0', '2020-05-06 12:01:07', '127.0.0.1', '2020-05-06 12:01:07'), ('29', 'qjkxr5ywnxkqw42bnn6pobr4z6zywn61r50mw9d14y0p3jdjzz', '0', 'weapon X!!', '', 'http://qzapp.qlogo.cn/qzapp/101870937/E11C10D22E5D1765988A959FC0415388/30', '6', '', '', '1', '1', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0', '0', '0', '0', '0', '0', '2020-05-11 15:43:05', '110.87.117.98', '2020-05-11 15:43:05'), ('30', 'qq244rxy5ondjymedqkw9020y1dzqmxr6oje4db0zzx95joxez', '0', '厦门宥理科技', '', 'http://qzapp.qlogo.cn/qzapp/101870937/D73A650184BA6BE0A09E236D7586551B/30', '8', '', '', '1', '1', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0', '0', '0', '0', '0', '0', '2020-05-11 15:18:00', '106.122.243.216', '2020-05-11 15:18:00'), ('32', '5brqxe2jdo1pmoq5', '15959250764', '', '$P$BC7YTw/LPggpWRYvyNwh5zf0B8ryZN/', '', '0', '', '121c83f760bd79dacb3', '1', '1', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0', '0', '0', '0', '0', '1', '2020-05-12 17:26:00', '117.30.218.143', '2020-05-12 17:26:00');
COMMIT;

-- ----------------------------
--  Table structure for `memberoauth`
-- ----------------------------
DROP TABLE IF EXISTS `memberoauth`;
CREATE TABLE `memberoauth` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `member_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '会员',
  `oauth_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'oauth',
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique` (`member_id`,`oauth_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
--  Records of `memberoauth`
-- ----------------------------
BEGIN;
INSERT INTO `memberoauth` VALUES ('11', '29', '118'), ('12', '30', '119');
COMMIT;

-- ----------------------------
--  Table structure for `menu`
-- ----------------------------
DROP TABLE IF EXISTS `menu`;
CREATE TABLE `menu` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '显示名',
  `parent` int(11) NOT NULL DEFAULT '0' COMMENT '上级',
  `path` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '层级关系',
  `url` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '特殊URL',
  `display` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否显示到左侧菜单(0为否,1为是,默认0)',
  `is_operation` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否是操作(0为否,1为是,默认0)',
  `list_order` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `created_by` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建人',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最近一次编辑时间',
  `updated_by` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后一次编辑人',
  PRIMARY KEY (`id`),
  KEY `parent` (`parent`) USING BTREE,
  KEY `display` (`display`) USING BTREE,
  KEY `is_operation` (`display`) USING BTREE,
  KEY `name` (`name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='菜单表';

-- ----------------------------
--  Records of `menu`
-- ----------------------------
BEGIN;
INSERT INTO `menu` VALUES ('1', '顶级菜单', '0', '0-', '0', '1', '0', '1', '2016-08-03 17:38:46', '66', '2020-03-16 11:02:16', '66'), ('2', '系统管理', '1', '0-1-', '0', '1', '0', '1', '2016-08-03 17:38:46', '66', '2020-03-16 11:02:16', '66'), ('3', '管理员管理', '2', '0-1-2-', '0', '1', '0', '99', '2016-10-02 14:40:55', '66', '2020-03-16 11:02:16', '66'), ('4', '角色管理', '2', '0-1-2-', '0', '1', '0', '12', '2016-09-20 14:05:40', '66', '2020-03-16 11:02:16', '66'), ('7', '查询角色', '4', '0-1-2-4-', '/admin/role/list', '0', '1', '1', '2018-12-25 15:35:02', '66', '2020-03-16 11:02:16', '66'), ('8', '创建角色', '4', '0-1-2-4-', '/admin/role/create', '0', '1', '2', '2018-12-25 15:35:34', '66', '2020-03-16 11:02:16', '66'), ('9', '编辑角色', '4', '0-1-2-4-', '/admin/role/edit', '0', '1', '3', '2018-12-25 15:35:56', '66', '2020-03-16 11:02:16', '66'), ('10', '删除角色', '4', '0-1-2-4-', '/admin/role/delete', '0', '1', '4', '2018-12-25 15:36:21', '66', '2020-03-16 11:02:16', '66'), ('11', '批量删除角色', '4', '0-1-2-4-', '/admin/role/batchDelete', '0', '1', '5', '2018-12-25 15:36:38', '66', '2020-03-16 11:02:16', '66'), ('12', '查询后台账号', '3', '0-1-2-3-', '/admin/user/list', '0', '1', '1', '2018-12-25 15:36:57', '66', '2020-03-16 11:02:16', '66'), ('13', '创建后台账号', '3', '0-1-2-3-', '/admin/user/create', '0', '1', '2', '2018-12-25 15:37:15', '66', '2020-03-16 11:02:16', '66'), ('14', '编辑后台账号', '3', '0-1-2-3-', '/admin/user/edit', '0', '1', '3', '2018-12-25 15:37:33', '66', '2020-03-16 11:02:16', '66'), ('15', '删除后台账号', '3', '0-1-2-3-', '/admin/user/delete', '0', '1', '4', '2018-12-25 15:37:54', '66', '2020-03-16 11:02:16', '66'), ('16', '批量删除后台账号', '3', '0-1-2-3-', '/admin/user/batchDelete', '0', '1', '5', '2018-12-25 15:38:12', '66', '2020-03-16 11:02:16', '66'), ('17', '权限管理', '2', '0-1-2-', '0', '1', '0', '1', '2020-03-12 09:51:53', '66', '2020-03-16 11:02:16', '66'), ('18', '创建权限', '17', '0-1-2-17-', '/admin/access/create', '0', '1', '1', '2020-03-12 09:53:42', '66', '2020-03-16 11:02:16', '66'), ('19', '浏览权限', '17', '0-1-2-17-', '/admin/access/list', '0', '1', '1', '2020-03-12 09:54:02', '66', '2020-03-16 11:02:16', '66'), ('20', '编辑权限', '17', '0-1-2-17-', '/admin/access/edit', '0', '1', '1', '2020-03-12 09:54:22', '66', '2020-03-16 11:02:16', '66'), ('21', '删除权限', '17', '0-1-2-17-', '/admin/access/delete', '0', '1', '1', '2020-03-12 09:54:42', '66', '2020-03-16 11:02:16', '66'), ('22', '会员管理', '1', '0-1-', '0', '1', '0', '0', '2020-03-13 12:39:23', '66', '2020-03-16 11:02:16', '66'), ('23', '会员管理', '22', '0-1-22-', '0', '1', '0', '0', '2020-03-13 12:40:20', '66', '2020-03-16 11:02:16', '66'), ('24', '浏览会员', '23', '0-1-22-23-', '/admin/member/list', '0', '1', '1', '2020-03-13 12:40:54', '66', '2020-03-16 11:02:16', '66'), ('25', '编辑会员', '23', '0-1-22-23-', '/admin/member/edit', '0', '1', '1', '2020-03-13 12:41:21', '66', '2020-03-16 11:02:16', '66'), ('26', '浏览单个会员信息', '23', '0-1-22-23-', '/admin/member/info', '0', '1', '1', '2020-03-13 12:41:50', '66', '2020-03-16 11:02:16', '66'), ('27', '删除会员', '23', '0-1-22-23-', '/admin/member/delete', '0', '1', '1', '2020-03-13 12:42:14', '66', '2020-03-16 11:02:16', '66'), ('28', '批量删除会员', '23', '0-1-22-23-', '/admin/member/batchdelete', '0', '1', '1', '2020-03-13 12:42:38', '66', '2020-03-16 11:02:16', '66'), ('29', '菜单管理', '2', '0-1-2-', '0', '1', '0', '1', '2020-03-13 18:44:37', '66', '2020-03-16 11:02:16', '66'), ('30', '浏览菜单', '29', '0-1-2-29-', '/admin/menu/list', '0', '1', '1', '2020-03-13 18:45:07', '66', '2020-03-16 11:02:16', '66'), ('31', '创建菜单', '29', '0-1-2-29-', '/admin/menu/create', '0', '1', '1', '2020-03-13 18:45:31', '66', '2020-03-16 11:02:16', '66'), ('32', '编辑菜单', '29', '0-1-2-29-', '/admin/menu/edit', '0', '1', '1', '2020-03-13 18:45:49', '66', '2020-03-16 11:02:16', '66'), ('33', '删除菜单', '29', '0-1-2-29-', '/admin/menu/delete', '0', '1', '1', '2020-03-13 18:46:12', '66', '2020-03-16 11:02:16', '66'), ('34', '消息管理', '2', '0-1-2-', '0', '1', '0', '1', '2016-08-03 17:38:46', '66', '2020-03-22 14:24:42', '66'), ('36', '读取系统消息列表', '39', '0-1-2-34-39-', '/admin/announce/list', '0', '1', '0', '2016-08-03 17:38:46', '66', '2020-03-22 14:25:17', '66'), ('37', '创建系统消息', '39', '0-1-2-34-39-', '/admin/announce/create', '0', '1', '0', '2016-08-03 17:38:46', '66', '2020-03-22 14:25:33', '66'), ('38', '编辑系统消息', '39', '0-1-2-34-39-', '/admin/announce/edit', '0', '1', '0', '2016-08-03 17:38:46', '66', '2020-03-22 14:25:47', '66'), ('39', '系统消息管理', '34', '0-1-2-34-', '0', '1', '0', '0', '2016-08-03 17:38:46', '66', '2020-03-22 14:24:42', '66'), ('40', '删除系统消息', '39', '0-1-2-34-39-', '/admin/announce/delete', '0', '1', '0', '2016-08-03 17:38:46', '66', '2020-03-22 14:36:45', '66'), ('41', '系统消息管理', '2', '0-1-2-', '0', '1', '0', '0', '2016-08-03 17:38:46', '66', '2020-03-16 11:02:16', '66'), ('42', '获取系统消息列表', '41', '0-1-2-41-', '/admin/announce/list', '0', '1', '0', '2016-08-03 17:38:46', '66', '2020-03-16 11:02:16', '66'), ('43', '创建系统消息', '41', '0-1-2-41-', '/admin/announce/create', '0', '1', '0', '2016-08-03 17:38:46', '66', '2020-03-16 11:02:16', '66'), ('44', '编辑系统消息接口', '41', '0-1-2-41-', '/admin/announce/edit', '0', '1', '0', '2016-08-03 17:38:46', '66', '2020-03-16 11:02:16', '66'), ('45', '查询消息推送状态', '39', '0-1-2-34-39-', '/admin/announce/info', '0', '1', '0', '2016-08-03 17:38:46', '66', '2020-04-03 22:29:13', '66'), ('46', '广告', '1', '0-1-', '0', '1', '0', '1', '2016-08-03 17:38:46', '66', '2020-04-11 14:59:44', '66'), ('47', '广告列表', '46', '0-1-46-', '/admin/ad/list', '0', '1', '0', '2016-08-03 17:38:46', '66', '2020-03-16 11:02:16', '66'), ('48', '添加广告', '46', '0-1-46-', '/admin/ad/create', '0', '1', '0', '2016-08-03 17:38:46', '66', '2020-04-11 14:59:44', '66'), ('49', '修改广告', '46', '0-1-46-', '/admin/ad/edit', '0', '1', '0', '2016-08-03 17:38:46', '66', '2020-04-11 14:59:44', '66'), ('50', '删除广告', '46', '0-1-46-', '/admin/ad/delete', '0', '1', '0', '2016-08-03 17:38:46', '66', '2020-04-11 14:59:44', '66'), ('51', '批量删除广告', '46', '0-1-46-', '/admin/ad/batchdelete', '0', '1', '0', '2016-08-03 17:38:46', '66', '2020-04-11 14:59:44', '66'), ('52', '商品管理', '2', '0-1-2-', '0', '1', '0', '0', '2016-08-03 17:38:46', '66', '2020-03-16 11:02:16', '66'), ('53', '1688商品管理', '52', '0-1-2-52-', '0', '1', '0', '0', '2016-08-03 17:38:46', '66', '2020-03-16 11:02:16', '66'), ('54', '1688产品管理', '53', '0-1-2-52-53-', '0', '1', '0', '0', '2016-08-03 17:38:46', '66', '2020-03-16 11:02:16', '66'), ('55', '1688商品分类管理', '53', '0-1-2-52-53-', '0', '1', '0', '0', '2016-08-03 17:38:46', '66', '2020-03-16 11:02:16', '66'), ('56', '获取1688商品列表接口', '54', '0-1-2-52-53-54-', '/admin/alibabaproduct/list', '0', '1', '0', '2016-08-03 17:38:46', '66', '2020-03-16 11:02:16', '66'), ('57', '获取1688商品详情接口', '54', '0-1-2-52-53-54-', '/admin/alibabaproduct/info', '0', '1', '0', '2016-08-03 17:38:46', '66', '2020-03-16 11:02:16', '66'), ('58', '编辑1688商品详情接口', '54', '0-1-2-52-53-54-', '/admin/alibabaproduct/edit', '0', '1', '0', '2016-08-03 17:38:46', '66', '2020-03-16 11:02:16', '66'), ('59', '获取1688商品分类列表接口', '55', '0-1-2-52-53-55-', '/admin/alibabacategory/list', '0', '1', '0', '2016-08-03 17:38:46', '66', '2020-03-16 11:02:16', '66'), ('60', '编辑1688商品分类接口', '55', '0-1-2-52-53-55-', '/admin/alibabacategory/edit', '0', '1', '0', '2016-08-03 17:38:46', '66', '2020-03-16 11:02:16', '66');
COMMIT;

-- ----------------------------
--  Table structure for `oauth`
-- ----------------------------
DROP TABLE IF EXISTS `oauth`;
CREATE TABLE `oauth` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `type` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '第三方平台(1为微博,2为微信,3为QQ,4为淘宝)',
  `open_id` varchar(50) NOT NULL DEFAULT '0' COMMENT '第三方open_id',
  `union_id` varchar(50) NOT NULL DEFAULT '0' COMMENT '用于微信与QQ的多应用绑定',
  `nickname` varchar(50) NOT NULL DEFAULT '0' COMMENT '第三方平台昵称',
  `avatar` varchar(255) NOT NULL DEFAULT '0' COMMENT '第三方平台头像',
  `sex` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '性别(0为女,1为男,2为未知,默认0)',
  `country` varchar(50) NOT NULL DEFAULT '中国' COMMENT '国家(默认中国)',
  `province` varchar(50) NOT NULL DEFAULT '0' COMMENT '省份(默认0)',
  `city` varchar(50) NOT NULL DEFAULT '0' COMMENT '城市(默认0)',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '第一次第三方授权时间',
  `stats` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '是否解绑(1为否,2为是,默认1)',
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique` (`open_id`,`type`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=120 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='第三方登录';

-- ----------------------------
--  Records of `oauth`
-- ----------------------------
BEGIN;
INSERT INTO `oauth` VALUES ('118', '3', 'E11C10D22E5D1765988A959FC0415388', 'E11C10D22E5D1765988A959FC0415388', 'weapon X!!', 'http://qzapp.qlogo.cn/qzapp/101870937/E11C10D22E5D1765988A959FC0415388/30', '0', '', '福建', '厦门', '2020-05-07 15:43:05', '1'), ('119', '3', 'D73A650184BA6BE0A09E236D7586551B', 'D73A650184BA6BE0A09E236D7586551B', '厦门宥理科技', 'http://qzapp.qlogo.cn/qzapp/101870937/D73A650184BA6BE0A09E236D7586551B/30', '1', '', '0', '0', '2020-05-10 15:18:00', '1');
COMMIT;

-- ----------------------------
--  Table structure for `order`
-- ----------------------------
DROP TABLE IF EXISTS `order`;
CREATE TABLE `order` (
  `sn` varchar(50) NOT NULL DEFAULT '' COMMENT '订单编号',
  `fail_sn` varchar(50) NOT NULL,
  `trade_order_sn` varchar(100) NOT NULL DEFAULT '0' COMMENT '1688订单号',
  `type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '订单类型(0为购买,1为兑换,默认0)',
  `product_id` varchar(16) NOT NULL DEFAULT '0' COMMENT '产品编号',
  `sku_id` varchar(13) NOT NULL DEFAULT '0' COMMENT 'sku编号',
  `activity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '活动编号',
  `member_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '下单会员',
  `fail_member_id` int(11) NOT NULL DEFAULT '0' COMMENT '拼团失败会员',
  `address_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '收货地址',
  `pay_type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '支付通道(0为支付宝,1为微信,默认0)',
  `amount` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '价格',
  `stats` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '状态(0待支付,1为待发货,2为已发货,3为确认收货,18下单失败,当type为1时,该字段默认值为1)',
  `refund_stats` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '退货退款状态(0为不退款不退货,1为发起退款,2为发起退货,3为退款成功,4为退货成功,5为退款失败,6为退货失败,7为退货等待买家发货,8为退货买家已发货,默认为0,当type为1时,该字段固定值0.当stats为1时方可发起退款,当stats为3时方可发起退货)',
  `rate_stats` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '评价状态(0为买家未评价,1为买家已评价,默认0,当stats为3时方可修改为1,买家评价后变为2)',
  `post_fee` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '运费',
  `notified_at` datetime DEFAULT NULL COMMENT '异步回调时间',
  `refunded_at` datetime DEFAULT NULL COMMENT '发起退款时间',
  `returned_at` datetime DEFAULT NULL COMMENT '发起退货时间',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '下单时间',
  `coupon_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '开始拼团时间',
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`sn`),
  KEY `type` (`type`) USING BTREE,
  KEY `product_id` (`product_id`) USING BTREE,
  KEY `sku_id` (`sku_id`) USING BTREE,
  KEY `activity_id` (`activity_id`) USING BTREE,
  KEY `member_id` (`member_id`) USING BTREE,
  KEY `address_id` (`address_id`) USING BTREE,
  KEY `pay_type` (`pay_type`) USING BTREE,
  KEY `stats` (`stats`) USING BTREE,
  KEY `refund_stats` (`refund_stats`) USING BTREE,
  KEY `refund_at` (`refunded_at`) USING BTREE,
  KEY `return_at` (`returned_at`),
  KEY `notified_at` (`notified_at`) USING BTREE,
  KEY `created_at` (`created_at`) USING BTREE,
  KEY `trade_order_sn` (`trade_order_sn`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='1688订单';

-- ----------------------------
--  Records of `order`
-- ----------------------------
BEGIN;
INSERT INTO `order` VALUES ('202004141851230643318736', '0', '1688-orderId-1588584138', '0', '584051070147', '4127294243179', '0', '6', '0', '4', '0', '14.40', '1', '0', '0', '1.00', '0000-00-00 00:00:00', '2020-05-11 20:01:01', '0000-00-00 00:00:00', '2020-05-11 17:00:00', '2020-06-11 16:45:00', '2020-05-12 19:24:14'), ('202004141851230643318737', '0', '1688-orderId-1588584139', '0', '584051070147', '4127294243179', '0', '6', '0', '4', '0', '14.40', '2', '2', '0', '1.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2020-05-11 20:02:02', '2020-05-11 17:01:00', '2020-06-11 16:46:00', '2020-05-11 20:20:25'), ('202004141851230643318738', '0', '0', '0', '584051070147', '4127294243179', '0', '6', '0', '4', '0', '14.40', '1', '3', '0', '1.00', '0000-00-00 00:00:00', '2020-05-11 20:03:03', '0000-00-00 00:00:00', '2020-05-11 17:03:00', '2020-06-11 16:47:00', '2020-05-11 20:15:46'), ('202004141851230643318739', '0', '1688-orderId-1588584140', '0', '584051070147', '4127294243179', '0', '6', '0', '4', '0', '14.40', '2', '4', '0', '1.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2020-05-11 20:04:04', '2020-05-11 17:03:00', '2020-06-11 16:47:00', '2020-05-11 20:21:26'), ('202004141851230643318740', '0', '0', '0', '584051070147', '4127294243179', '0', '6', '0', '4', '0', '14.40', '1', '5', '0', '1.00', '0000-00-00 00:00:00', '2020-05-11 20:05:05', '0000-00-00 00:00:00', '2020-05-11 17:03:00', '2020-06-11 16:48:00', '2020-05-11 20:17:41'), ('202004141851230643318741', '0', '1688-orderId-1588584141', '0', '584051070147', '4127294243179', '0', '6', '0', '4', '0', '14.40', '2', '6', '0', '1.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2020-05-11 20:06:06', '2020-05-11 17:04:00', '2020-06-11 16:49:00', '2020-05-11 20:21:34'), ('202004141851230643318742', '0', '1688-orderId-1588584142', '0', '584051070147', '4127294243179', '0', '6', '0', '4', '0', '14.40', '2', '7', '0', '1.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2020-05-11 20:07:07', '2020-05-11 17:05:00', '2020-06-11 16:50:00', '2020-05-11 20:21:36'), ('202004141851230643318743', '0', '1688-orderId-1588584143', '0', '584051070147', '4127294243179', '0', '6', '0', '4', '0', '14.40', '2', '8', '0', '1.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2020-05-11 20:08:08', '2020-05-11 17:06:00', '2020-06-11 16:51:00', '2020-05-11 20:21:38');
COMMIT;

-- ----------------------------
--  Table structure for `refundinfo`
-- ----------------------------
DROP TABLE IF EXISTS `refundinfo`;
CREATE TABLE `refundinfo` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
  `reason` varchar(255) NOT NULL DEFAULT '' COMMENT '退款退货原因',
  `type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '信息类型(1退款 2退货,默认1)',
  `album_id` int(11) NOT NULL DEFAULT '0' COMMENT '凭证',
  `order_sn` varchar(50) NOT NULL DEFAULT '' COMMENT '订单编号 order中sn',
  `refund_order_id` varchar(100) NOT NULL DEFAULT '' COMMENT '退款、退货订单号(1688返回)',
  `logistics` longtext COMMENT '物流信息',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `created_by` int(11) NOT NULL DEFAULT '0' COMMENT '创建人',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最近一次编辑时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `order_sn` (`order_sn`)
) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='退货/退款原因信息表';

-- ----------------------------
--  Records of `refundinfo`
-- ----------------------------
BEGIN;
INSERT INTO `refundinfo` VALUES ('57', '圣诞节开发', '1', '133', '202004141851230643318735', 'TK202004141851230643318735', 'a:5:{s:8:\"order_sn\";s:24:\"202004141851230643318735\";s:20:\"logistics_company_no\";s:1:\"1\";s:12:\"freight_bill\";s:10:\"3123asdsad\";s:11:\"description\";s:22:\"123123asdf阿斯蒂芬\";s:8:\"album_id\";s:3:\"137\";}', '2020-05-05 21:01:28', '0', '2020-05-11 21:25:50'), ('58', '发起退货', '1', '0', '202004141851230643318737', 'TK202004141851230643318737', null, '2020-05-11 21:22:54', '0', '2020-05-11 21:25:46'), ('59', '退款成功订单', '1', '0', '202004141851230643318738', 'TK202004141851230643318738', null, '2020-05-11 21:23:36', '0', '2020-05-11 21:25:42'), ('60', '退货成功订单', '1', '133', '202004141851230643318739', 'TK202004141851230643318739', 'a:5:{s:8:\"order_sn\";s:24:\"202004141851230643318735\";s:20:\"logistics_company_no\";s:1:\"1\";s:12:\"freight_bill\";s:10:\"3123asdsad\";s:11:\"description\";s:22:\"123123asdf阿斯蒂芬\";s:8:\"album_id\";s:3:\"137\";}', '2020-05-11 21:24:04', '0', '2020-05-11 21:25:40'), ('61', '退款失败订单', '1', '0', '202004141851230643318740', 'TK202004141851230643318740', null, '2020-05-11 21:24:42', '0', '2020-05-11 21:25:34'), ('62', '退货失败订单', '1', '133', '202004141851230643318741', 'TK202004141851230643318741', 'a:5:{s:8:\"order_sn\";s:24:\"202004141851230643318735\";s:20:\"logistics_company_no\";s:1:\"1\";s:12:\"freight_bill\";s:10:\"3123asdsad\";s:11:\"description\";s:22:\"123123asdf阿斯蒂芬\";s:8:\"album_id\";s:3:\"137\";}', '2020-05-11 21:25:19', '0', '2020-05-11 21:25:31'), ('63', '等待买家发货退货订单', '1', '133', '202004141851230643318742', 'TK202004141851230643318742', 'a:5:{s:8:\"order_sn\";s:24:\"202004141851230643318735\";s:20:\"logistics_company_no\";s:1:\"1\";s:12:\"freight_bill\";s:10:\"3123asdsad\";s:11:\"description\";s:22:\"123123asdf阿斯蒂芬\";s:8:\"album_id\";s:3:\"137\";}', '2020-05-11 21:26:09', '0', '2020-05-11 21:26:15'), ('64', '买家已发货的退货订单', '1', '133', '202004141851230643318743', 'TK202004141851230643318743', 'a:5:{s:8:\"order_sn\";s:24:\"202004141851230643318735\";s:20:\"logistics_company_no\";s:1:\"1\";s:12:\"freight_bill\";s:10:\"3123asdsad\";s:11:\"description\";s:22:\"123123asdf阿斯蒂芬\";s:8:\"album_id\";s:3:\"137\";}', '2020-05-11 21:26:35', '0', '2020-05-11 21:26:36');
COMMIT;

-- ----------------------------
--  Table structure for `role`
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '角色',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `created_by` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建人',
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后一次修改时间',
  `updated_by` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后一次修改人',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='角色表';

-- ----------------------------
--  Records of `role`
-- ----------------------------
BEGIN;
INSERT INTO `role` VALUES ('1', '超级管理员', '2018-12-25 08:50:56', '66', '2020-04-12 16:16:11', '66'), ('2', '管理员', '2019-01-04 05:36:06', '66', '2020-03-21 18:10:40', '66');
COMMIT;

-- ----------------------------
--  Table structure for `rule`
-- ----------------------------
DROP TABLE IF EXISTS `rule`;
CREATE TABLE `rule` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '权限名称',
  `stats` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '状态(0为否,1为是,默认1)',
  `created_by` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建者',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_by` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新者',
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='权限表';

-- ----------------------------
--  Records of `rule`
-- ----------------------------
BEGIN;
INSERT INTO `rule` VALUES ('1', '后台角色管理', '1', '66', '2020-03-12 09:42:06', '66', '2020-03-16 11:01:40'), ('2', '后台账号管理', '1', '66', '2020-03-12 09:42:20', '66', '2020-03-16 11:01:38'), ('3', '后台权限管理', '1', '66', '2020-03-12 09:42:35', '66', '2020-03-16 11:01:34'), ('4', '订单管理', '1', '66', '2020-03-12 09:42:43', '66', '2020-03-16 11:01:35'), ('5', '会员管理', '1', '66', '2020-03-12 09:42:48', '66', '2020-03-24 12:55:50'), ('6', '后台菜单管理', '1', '66', '2020-03-13 18:46:40', '66', '2020-03-13 18:46:40'), ('8', '阿里巴巴产品管理员', '0', '66', '2020-03-16 00:06:05', '66', '2020-04-12 16:15:05'), ('9', '会员收货地址管理', '0', '66', '2020-03-19 10:08:28', '66', '2020-03-19 10:08:28'), ('10', '财务管理', '0', '66', '2020-03-21 13:30:31', '66', '2020-03-23 15:52:08'), ('16', '系统设置', '0', '66', '2020-03-24 14:23:21', '66', '2020-03-24 14:23:21'), ('17', '系统消息管理员', '0', '66', '2020-04-01 10:01:25', '66', '2020-04-03 22:29:31'), ('18', '广告管理员', '0', '66', '2020-04-12 11:04:34', '66', '2020-04-12 11:04:34'), ('19', '阿里巴巴产品分类管理员', '0', '66', '2020-04-12 16:16:00', '66', '2020-04-12 16:16:00');
COMMIT;

-- ----------------------------
--  Table structure for `system`
-- ----------------------------
DROP TABLE IF EXISTS `system`;
CREATE TABLE `system` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `exchange_rate` decimal(10,2) unsigned NOT NULL DEFAULT '1000.00' COMMENT '兑换商品所需的积分与商品价格的比例(单位%,默认1000%)',
  `coupon_expire` int(10) unsigned NOT NULL DEFAULT '600' COMMENT '拼团等待时间(单位秒,默认10分钟)',
  `coupon_bot_rate` decimal(10,2) unsigned NOT NULL DEFAULT '30.00' COMMENT '机器人参与评团时的胜率(单位:%,默认30%)',
  `alibaba_price` decimal(10,2) unsigned NOT NULL DEFAULT '300.00' COMMENT '商品售价倍数(默认300)',
  `rebate_rate` decimal(10,2) unsigned NOT NULL DEFAULT '40.00' COMMENT '拼团失败用户的返利比例(单位:%,默认40%)',
  `title` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '网站标题',
  `title_suffix` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '网站标题后缀',
  `keywords` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '关键词',
  `description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '描述',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='系统';

-- ----------------------------
--  Records of `system`
-- ----------------------------
BEGIN;
INSERT INTO `system` VALUES ('1', '150.00', '1200', '1.00', '3000.00', '23.00', '网站标题222', '网站标题后缀333', '网站,关键词,123', '网站描述123');
COMMIT;

-- ----------------------------
--  Table structure for `turnover`
-- ----------------------------
DROP TABLE IF EXISTS `turnover`;
CREATE TABLE `turnover` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `member_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '会员',
  `account_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '提现账号',
  `type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '类型(0为金币转入,1为金币消费,2为金币转余额,3为金币转余额,4为退回余额,5为余额提现)',
  `currency` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '扣款前',
  `amount` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '金额',
  `remain` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '扣款后',
  `stats` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '状态(0为待审核,1为审核通过,2为审核拒绝,默认0)',
  `remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '备注',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '审核时间',
  `updated_by` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '审核者',
  PRIMARY KEY (`id`),
  KEY `member_id` (`member_id`) USING BTREE,
  KEY `stats` (`stats`) USING BTREE,
  KEY `type` (`type`) USING BTREE,
  KEY `created_at` (`created_at`) USING BTREE,
  KEY `updated_at` (`updated_at`) USING BTREE,
  KEY `updated_by` (`updated_by`) USING BTREE,
  KEY `account_id` (`account_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='金币余额流水';

-- ----------------------------
--  Records of `turnover`
-- ----------------------------
BEGIN;
INSERT INTO `turnover` VALUES ('1', '6', '2', '5', '200.00', '-100.00', '100.00', '1', '13333333333于2020-03-23 20:39:44完成审核。审核状态为:通过\r\n', '2020-03-21 11:33:55', '2020-03-23 20:39:44', '66'), ('10', '6', '0', '2', '300.00', '-10.00', '290.00', '1', '金币转余额的金币减少记录', '2020-03-21 12:24:23', '2020-03-21 13:37:12', '0'), ('11', '6', '0', '3', '100.00', '8.00', '108.00', '1', '金币转余额的余额增加记录', '2020-03-21 12:24:23', '2020-03-21 13:37:10', '0'), ('18', '6', '0', '2', '290.00', '-100.00', '190.00', '1', '金币转余额的金币减少记录', '2020-03-21 12:30:19', '2020-03-21 13:36:58', '0'), ('19', '6', '0', '3', '108.00', '80.00', '188.00', '1', '金币转余额的余额增加记录', '2020-03-21 12:30:19', '2020-03-21 13:37:08', '0'), ('20', '6', '0', '4', '188.00', '100.00', '288.00', '1', '拒绝提现，归还余额', '2020-03-21 14:46:16', '2020-03-24 11:29:01', '0'), ('22', '6', '0', '4', '288.00', '100.00', '388.00', '1', '拒绝提现，归还余额', '2020-03-23 16:52:10', '2020-03-24 11:29:03', '0'), ('23', '6', '0', '0', '190.00', '50.00', '240.00', '1', '金币转入记录', '2020-03-24 10:48:01', '2020-03-24 10:48:01', '0');
COMMIT;

-- ----------------------------
--  Table structure for `user`
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `username` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '登录名',
  `password` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '密码',
  `google_secret` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '谷歌认证器',
  `role` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '角色',
  `mobile` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '手机号码',
  `stats` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '状态(0为封禁,1为允许登录,默认0)',
  `uuid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT 'uuid',
  `last_login_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '上次登录时间',
  `login_times` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '登录次数',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `created_by` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建人',
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '最后一次修改时间',
  `updated_by` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后一次修改人',
  PRIMARY KEY (`id`),
  UNIQUE KEY `mobile` (`mobile`) USING BTREE,
  UNIQUE KEY `username` (`username`) USING BTREE,
  KEY `stats` (`stats`) USING BTREE,
  KEY `role` (`role`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=193 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='后台账号表';

-- ----------------------------
--  Records of `user`
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES ('66', '13333333333', '$P$BZS5YTkXJeFknzjBB5yyOZ7tqVX7GU0', 'NNXMLV2SONUMJDAP', '1', '13333333333', '1', '1lqn6jzp06pbmd9w', '2020-05-12 15:48:54', '124', '2018-12-25 08:50:48', '66', '2020-01-31 10:36:32', '66');
COMMIT;

-- ----------------------------
--  Table structure for `withdraw`
-- ----------------------------
DROP TABLE IF EXISTS `withdraw`;
CREATE TABLE `withdraw` (
  `sn` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '提款订单编号',
  `out_trade_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '上游订单号',
  `member_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '提款会员',
  `account_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '账号信息',
  `turnover_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '流水记录',
  `type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '类型(0为支付宝,1为微信,2为银行卡,默认0)',
  `amount` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '提款金额',
  `stats` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '状态(0为待打款,1为已打款,3为打款成功,4为打款失败,默认0)',
  `remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '打款失败',
  `notified_at` datetime DEFAULT NULL COMMENT '异步回调时间',
  `created_by` int(11) NOT NULL DEFAULT '0' COMMENT '审核人员',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_by` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '编辑者',
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '编辑时间',
  PRIMARY KEY (`sn`),
  UNIQUE KEY `order_sn` (`sn`) USING BTREE,
  KEY `member_id` (`member_id`) USING BTREE,
  KEY `account_id` (`account_id`) USING BTREE,
  KEY `turnover_id` (`turnover_id`) USING BTREE,
  KEY `stats` (`stats`) USING BTREE,
  KEY `created_at` (`created_at`) USING BTREE,
  KEY `updated_at` (`updated_at`) USING BTREE,
  KEY `notified_at` (`notified_at`) USING BTREE,
  KEY `type` (`type`) USING BTREE,
  KEY `out_trade_no` (`out_trade_no`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='提款订单';

-- ----------------------------
--  Records of `withdraw`
-- ----------------------------
BEGIN;
INSERT INTO `withdraw` VALUES ('202003232039440643330641', '0', '6', '2', '1', '0', '100.00', '0', '', null, '66', '2020-03-23 20:39:44', '0', '2020-03-24 09:34:55');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
